Excvel 2003: Conditional Formatting

O

oceanmist

I made up a vacation schedule and when I put the number of hours taken in a
cell I want the cell background to change to yellow. How do I do that?
 
D

Dave F

Enter the formula =NOT(ISBLANK(A1)) in the condition window for the cell in
question. Tell XL to format the background yellow if the cell's contents
meet that condition (i.e., the cell is not blank).
 
Top