Excvel 2003: Conditional Formatting
 

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?

Excvel 2003: Conditional Formatting
 

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).
--
Brevity is the soul of wit.


"oceanmist" wrote:

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?