Row Formatting

  • Thread starter Thread starter Anthony
  • Start date Start date
A

Anthony

I'm searching for a formula which would change the font
color for the entire row, based on the information in a
cell (date-data) located on that row. Example:
cell F3 "20-Mar-98"; cell G3 contain data which is 4years
6month from cell F3. I completed this formula. I'm
looking for a formula which will change the color of the
entire row based off today's date. When G3 is < TODAY()
then---font=red; When G3 is > TODAY() and <180+1 days--
font= yellow; When G3 is > TODAY() and < 90+1 days--font =
green. I hope this is clear: Using today's date: 15 MAY
03 = FONT RED; 15 SEP 03= FONT GREEN; 15 Feb 04 = FONT
YELLOW. Thanks in advance for the help!
 
What is wrong with the reply you got to this same question in
Worksheet.Functions a couple of days ago?
 
Anthony,

A formula will not change/add cell formatting. You can however use
Conditional Formatting and use the formula you have indicated as the
criteria.

Format|Conditional Format...

HTH

PC
 
Back
Top