| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting of rows | Excel Discussion (Misc queries) | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional Formatting Cell < Today() | Excel Worksheet Functions | |||
| Conditional Formatting | Excel Discussion (Misc queries) | |||
| EXCEL 2003: Apply Conditional Formatting to COLUMNS | Excel Worksheet Functions | |||
Linear Mode
