|
graphical indicator
Hello,
I have a spreadsheet with the following columns: 1. Project Name 2. Status 3. Original ECD (estimated date of comletion) 4. New ECD I need to insert graphical indicators that show Red, Yellow, Green based on #3 above. Green €“ Projects are within their estimates and their ECDs Yellow €“ ECD =< 14 days (e.g., ECD=4/2/07 and today is 3/19/07) Red €“ Todays date = ECD How can I do this in Excel? |
graphical indicator
Conditional Formatting
Condition 1: =A1<=TODAY()-14 format cell as yellow Condition 2: =A1<=TODAY() format cell as red "HL" wrote: Hello, I have a spreadsheet with the following columns: 1. Project Name 2. Status 3. Original ECD (estimated date of comletion) 4. New ECD I need to insert graphical indicators that show Red, Yellow, Green based on #3 above. Green €“ Projects are within their estimates and their ECDs Yellow €“ ECD =< 14 days (e.g., ECD=4/2/07 and today is 3/19/07) Red €“ Todays date = ECD How can I do this in Excel? |
| All times are GMT +1. The time now is 10:38 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com