Cond. format. to change color based on dates
Closed
T
-
Aug 5, 2009 at 12:51 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 5, 2009 at 10:06 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 5, 2009 at 10:06 PM
Related:
- Cond. format. to change color based on dates
- Notepad++ change background color - Guide
- How to change whatsapp time format - Guide
- How to change date format in excel - Guide
- Format factory - Download - Other
- Change computer name cmd - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 5, 2009 at 10:06 PM
Aug 5, 2009 at 10:06 PM
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
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
