condition formatting with formula

B

BHOOI

Hai. I need a hekp to solve this problem of condition formatting with
formula. Please refer to the cell:-
A B
1 50 4
2 100 3
3 60 10
4 80 7
5 92 5

If I want to put colour blue colour in A1 to A4 with the condition if B>6
If I want to put colour red colour in A1 to A4 with the condition if B>4
If I want to put colour blue colour in A1 to A4 with the condition if B>2

Thanks
 
J

JE McGimpsey

One way:

Select A1:A4 with A1 the active cell.

Choose Format/Conditional Formatting...

CF1: Formula is =B1>6
Format1: <blue>

CF2: Formula is =B1>4
Format2: <red>

CF3: Formula is =B1>2
Format3: <blue>
 
Top