Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Based on Date
How can I change the fill color of a cell based on a date. I would like the
cell to be green if the date in a cell is equal to or greater than 90 days from todays date. Yellow if less than or equal to 90 days and Red if less than or equal to 30 day from the current date. This is to track when an employee's annual training is due. -- Aloha, Ron A. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Based on Date
Conditional Formatting
Click in the cell, say A3, then, from the menu Bar: <Format <Conditional Formatting, Change "Cell Value Is" to "Formula Is", and enter this: =AND(A3<"",A3=TODAY()+90) Click on "Format", and choose a Pattern of Green, Then click on "Add" for the second condition, Change "Cell Value Is" to "Formula Is", and enter this: =AND(A3<"",A3<=TODAY()+30) Click on "Format", and choose a Pattern of Red, Then click on "Add" for the third condition, Change "Cell Value Is" to "Formula Is", and enter this: =AND(A3<"",A3<TODAY()+90) Click on "Format", and choose a Pattern of Yellow. Then <OK out, and you should be done. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron A." wrote in message news:B71D8B5A-9858-4B1E-B6C1-2D20458 ... How can I change the fill color of a cell based on a date. I would like the cell to be green if the date in a cell is equal to or greater than 90 days from todays date. Yellow if less than or equal to 90 days and Red if less than or equal to 30 day from the current date. This is to track when an employee's annual training is due. -- Aloha, Ron A. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Based on Date
Thank you both for your reply. Exactly what I needed.
-- Aloha, Ron A. "RagDyer" wrote: Conditional Formatting Click in the cell, say A3, then, from the menu Bar: <Format <Conditional Formatting, Change "Cell Value Is" to "Formula Is", and enter this: =AND(A3<"",A3=TODAY()+90) Click on "Format", and choose a Pattern of Green, Then click on "Add" for the second condition, Change "Cell Value Is" to "Formula Is", and enter this: =AND(A3<"",A3<=TODAY()+30) Click on "Format", and choose a Pattern of Red, Then click on "Add" for the third condition, Change "Cell Value Is" to "Formula Is", and enter this: =AND(A3<"",A3<TODAY()+90) Click on "Format", and choose a Pattern of Yellow. Then <OK out, and you should be done. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron A." wrote in message news:B71D8B5A-9858-4B1E-B6C1-2D20458 ... How can I change the fill color of a cell based on a date. I would like the cell to be green if the date in a cell is equal to or greater than 90 days from todays date. Yellow if less than or equal to 90 days and Red if less than or equal to 30 day from the current date. This is to track when an employee's annual training is due. -- Aloha, Ron A. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Format Based on Date
You're welcome and thank you for the feedback.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron A." wrote in message ... Thank you both for your reply. Exactly what I needed. -- Aloha, Ron A. "RagDyer" wrote: Conditional Formatting Click in the cell, say A3, then, from the menu Bar: <Format <Conditional Formatting, Change "Cell Value Is" to "Formula Is", and enter this: =AND(A3<"",A3=TODAY()+90) Click on "Format", and choose a Pattern of Green, Then click on "Add" for the second condition, Change "Cell Value Is" to "Formula Is", and enter this: =AND(A3<"",A3<=TODAY()+30) Click on "Format", and choose a Pattern of Red, Then click on "Add" for the third condition, Change "Cell Value Is" to "Formula Is", and enter this: =AND(A3<"",A3<TODAY()+90) Click on "Format", and choose a Pattern of Yellow. Then <OK out, and you should be done. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ron A." wrote in message news:B71D8B5A-9858-4B1E-B6C1-2D20458 ... How can I change the fill color of a cell based on a date. I would like the cell to be green if the date in a cell is equal to or greater than 90 days from todays date. Yellow if less than or equal to 90 days and Red if less than or equal to 30 day from the current date. This is to track when an employee's annual training is due. -- Aloha, Ron A. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format based on date | Excel Worksheet Functions | |||
Conditional Sum based on Bold Format | Excel Discussion (Misc queries) | |||
how do you conditional format based upon today's date? | Excel Worksheet Functions | |||
Conditional Format based on date ranges | Excel Worksheet Functions | |||
Conditional Format based on range | Excel Discussion (Misc queries) |