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.