View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Formate colour of cells

Highlight your range
Conditional Formatting
Condition 1: =$A$1=1 (Format as Red)
Condition 2: =$A$2=2 (Format as Green)

"Bela" wrote:

I have the value 1 in cell (A,1) then I wan´t the colour to change to red in
cells (B1:F1) or if I have the value 2 in cell (A1) then colour should change
to green in cells (B1:F1)