Change colour of cell if there is no value

[Guest]

Using selected cells only (some already contain a IF statement or data) I
want to have cells change colour if there is no value or data in it. That is
if data or value is then entered it would revert back to no fill.

 

[Guest]

Thanks Max what an angle

Select the desired range, say B210 (with B2 active)
Click Format > Conditional Formatting
Under Condition 1, make it as
Formula is:=B2=""
Format > Pattern > Light green? > OK
Click OK at the main dialog

(Above assumes B210 contains no "normal" fill color)

 

[Guest]

Thanks Max what an angle

Select the desired range, say B210 (with B2 active)
Click Format > Conditional Formatting
Under Condition 1, make it as
Formula is:=B2=""
Format > Pattern > Light green? > OK
Click OK at the main dialog

(Above assumes B210 contains no "normal" fill color)

 

[Guest]

You're welcome !

 

[Guest]

You're welcome !