cond. format. to change color based on dates Closed

Question

Hello,
        I need excel help (formulas or conditional formatting). I am trying to change the highlight color of a cell based on the value (date) in the cell compared to the current date. For example if todays date is 8/5/09 and the date in a cell is prior then it would be red and if the date in the cell is in the future it would be green.
any help would be greatly appreciated.

venkat1926 · Answer

you have  to use conditional formatting.
 
In an empty cell for e.g. D1 type this formula 
=today()

now select the first cell where dates are parked
click format-conditional formatting 
under condition 1 
the first window 
"cell value is"
second right window
click the arrow and choose 
"greater than or equal to"
in the third right window type 
$D$1
now click "foramt" in he next row
choose patter
choose green colour 
click ok only once
you now automatically go back to conditional formatting window
now click "add" at the bottom
first window as before is
"cell valuae is"
in the second window choose less then 
in the third window as before type 
$D$1
click format -patter
choose red colour
click ok
again click ok

now copy this cell
highlight cells below 
click
edit-pastespecial-format-ok

now see whetehr you get what you ant

Cond. format. to change color based on dates

1 response

Similar discussions

Subscribe To Our Newsletter!