condition formatting with formula
 

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 B6
If I want to put colour red colour in A1 to A4 with the condition if B4
If I want to put colour blue colour in A1 to A4 with the condition if B2

Thanks

condition formatting with formula
 

One way:

Select A1:A4 with A1 the active cell.

Choose Format/Conditional Formatting...

CF1: Formula is =B16
Format1: <blue

CF2: Formula is =B14
Format2: <red

CF3: Formula is =B12
Format3: <blue

In article ,
BHOOI wrote:

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 B6
If I want to put colour red colour in A1 to A4 with the condition if B4
If I want to put colour blue colour in A1 to A4 with the condition if B2

Thanks