Select the desired range, say B2:D10 (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 B2:D10 contains no "normal" fill color)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Jennifer1960" wrote:
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.