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
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Use conditional formatting with a formula of =E5>VLOOKUP(F5,$J$5:$K$10,2,FALSE)
 

Dnyan

New member
Joined
Aug 1, 2011
Messages
14
Reaction score
0
Points
0
Location
Mumbai
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

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
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

New member
Joined
Aug 1, 2011
Messages
14
Reaction score
0
Points
0
Location
Mumbai
Hi,

Yes, now its working properly

Thanks you very much for help
 
Top