hilght cells at a give day

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.



chuck irven (e-mail address removed) <chuck irven
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting to test blank text cell 4
How do I use conditional formatting to hilite weekend dates where. 1
Condl formtng of range of cells based on one value 1
Comparison of columns using Conditional Formatting 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Testing a cell value for a specific weekday. 3
Cell color changes when date gets closer 2
formula to change font or cell colour 3

Back
Top