formatting

[jackdiamond]

Morning all,

I want to be able to turn cell C2 green if C6 is greater than 4 and red if it is less than 4.

is there a way I can do this please?

thank you in advance

Jack

 

[Benjaminmin]

When on the cell, Go to "format", "conditional formatting"
chose Cell Value "is greater than" 4
And
Cell Value "is less than" 4
and then click the "format" button for both of them and chose the shading

 

[jackdiamond]

Yes, that will turn my current cell the desired colour but I want to turn C2 a certain colour depending on the value of C4

 

[Benjaminmin]

Yes, that will turn my current cell the desired colour but I want to turn C2 a certain colour depending on the value of C4

Then in conditional formatting, instead of cell value, chose Formula is, and then C4>4 and C4<4 in the 2nd line