Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for high lighting rows
I would like to look into a cell and return a high lighted row.
if todays date is less than 5 days prior the date in the cell, high light the row green if todays date is between 5 and 0 days prior the date in the cell, high light the row amber if todays date is 0 days prior or greater the date in the cell, high light the row red Can anyone help? Thanks, -- Clint |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
formula for high lighting rows
Try Conditional Formatting.
"Clint" wrote in message ... I would like to look into a cell and return a high lighted row. if todays date is less than 5 days prior the date in the cell, high light the row green if todays date is between 5 and 0 days prior the date in the cell, high light the row amber if todays date is 0 days prior or greater the date in the cell, high light the row red Can anyone help? Thanks, -- Clint |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
High Lighting cells | New Users to Excel | |||
High Lighting cells with conditional colour formats | Excel Discussion (Misc queries) | |||
Autofit Height of Rows too High | Excel Discussion (Misc queries) | |||
high lighting | Excel Discussion (Misc queries) | |||
Code stops when high lighting (Chips code) | Excel Programming |