View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
BHOOI BHOOI is offline
external usenet poster
 
Posts: 1
Default 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