applying conditional formatting

  • Thread starter Thread starter shanemarkley
  • Start date Start date
S

shanemarkley

I'm trying to apply a conditional format to my table that will change
the background color of ever cell that is blank to a light gray. The
farmat I apply is Cell Value IS equal to and then I leave the third box
blank and set the format background color to gray. Is there something
wrong with the formula I created or is there something else I need to
do to apply the conditional format to the table? :confused:
 
Try this ..

Select the target range, say A1:E10

Click Format > Conditional Formatting
Under Condition 1, make the settings:
Formula is | =A1=""
Click Format > Patterns tab > Light gray > OK
Click OK
 
Back
Top