G
Guest
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
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