PDA

View Full Version : Conditional Formating Help

Dnyan
2011-08-03, 08:09 AM
Hi,

I am making one tracker and I want to make conditional formating in this sheet.

Wants to apply conditions on coloumn E & F Product and his limit.
For Exaple: if multiple value of EL is given coloumn E then conditional formating required for coloumn F i.e. if Amount is >+ 25000 then colour is red

Product

Limit >=

EL

25000

PL

25000

MD

1000000

TH

10000

MNY

10000

CAR

25000

Please give me the solution.

Regards
Dnyan188

Bob Phillips
2011-08-03, 08:56 AM
Use conditional formatting with a formula of =E5>VLOOKUP(F5,\$J\$5:\$K\$10,2,FALSE)

Dnyan
2011-08-03, 09:05 AM
Hi,

Thanks for help
but I think this formula for only one row i.e. E5 & F5.

I want conditional formation for column E & F

Bob Phillips
2011-08-03, 10:28 AM
No, you select all of the cells that you want the CF to apply to, starting with E5, and then set the CF formula for them all in one fell swoop.

Dnyan
2011-08-03, 10:37 AM
Hi,

Yes, now its working properly

Thanks you very much for help