Conditional formating based on numbers and texts

arun.sj

New member
Joined
Jun 30, 2014
Messages
1
Reaction score
0
Points
0
Hi Team,

i have coloumn A with Different status like Open, closed, available etc. Coloumn B have numbers.

i am looking for a formula in condition formating for coloumn B.

If the cell value in coloumn B is 2 or more, the same cell should be highlighted in Green.
If the cell value in coloumn B is 1, the same cell should be highlighted in Yellow.
If the cell value in coloumn B is 0, the same cell should be highlighted in Amber.
If the cell value in coloumn B is less than 0, the same cell should be highlighted in Red.

If the cell value in coloumn A is "Available", cell in coloumn B should be highlighted in Amber.

Please help
 

Bob Phillips

Super Moderator
Staff member
Joined
Mar 21, 2011
Messages
1,940
Reaction score
0
Points
36
Excel Version(s)
O365
Seems simple

Amber: OR($A2="Available",$B2=0)
Green: $B2>=2
Yellow: $B2=1
Red: $B2<0
 
Top