| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
hilght cells at a give day
I would like to know if there is a way to have cells flash or hilight on a
day or time I set for them ? ie. when a date for renewal comes due the date cell flashes or hilights to a differant color say 2 days before ? hope some on can help. |
|
#2
|
|||
|
|||
|
Take a look at conditional formatting in XL Help.
For instance, if A1 has your date, select A1 and use: CF1: =(A1-TODAY) <= 2 Format1: Pattern/<color Don't flash. Just don't. It's annoying. In article , chuck irven <chuck irven wrote: I would like to know if there is a way to have cells flash or hilight on a day or time I set for them ? ie. when a date for renewal comes due the date cell flashes or hilights to a differant color say 2 days before ? hope some on can help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| monitoring a changing range of cells | Excel Worksheet Functions | |||
| Skipping cells while reorganizing data | Excel Discussion (Misc queries) | |||
| REVISED ?? - populate limited cells w/ set value | Excel Worksheet Functions | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| How can I put cells in front of a picture? | Excel Discussion (Misc queries) | |||
Linear Mode
