Conditional Formating Help

Dnyan

New member
Joined
Aug 1, 2011
Messages
14
Reaction score
0
Points
0
Location
Mumbai
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
DnyanView attachment claims.xls
 
Use conditional formatting with a formula of =E5>VLOOKUP(F5,$J$5:$K$10,2,FALSE)
 
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
 
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.
 
Hi,

Yes, now its working properly

Thanks you very much for help
 
Back
Top