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)
|