Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to change the cell format (color) based on a calc
I have a spreadsheet with due dates and current date - I want to change the
status on those tasks based on calculation of due date against current date. If due date has passed - I want to turn cell "red", if not passed thenn "green" if same day then "yellow". How can I do this? thanks ! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to change the cell format (color) based on a calc
See http://xldynamic.com/source/xld.CF.html#due
-- __________________________________ HTH Bob "mtnmanus" wrote in message ... I have a spreadsheet with due dates and current date - I want to change the status on those tasks based on calculation of due date against current date. If due date has passed - I want to turn cell "red", if not passed thenn "green" if same day then "yellow". How can I do this? thanks ! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to change the cell format (color) based on a calc
Hi
Check out Conditional formatting. Cond. form. together with dates has been dealt with many times in the earlier newsgroup postings, so you can use the search function and you will surely find your solution. If not, please ask further. -- Wigi http://www.wimgielis.be = Excel/VBA, soccer and music "mtnmanus" wrote: I have a spreadsheet with due dates and current date - I want to change the status on those tasks based on calculation of due date against current date. If due date has passed - I want to turn cell "red", if not passed thenn "green" if same day then "yellow". How can I do this? thanks ! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to change the cell format (color) based on a calc
Take a look at condtional formatting
Format - Conditonal Formatting Use the Today() function to get the current date. -- HTH... Jim Thomlinson "mtnmanus" wrote: I have a spreadsheet with due dates and current date - I want to change the status on those tasks based on calculation of due date against current date. If due date has passed - I want to turn cell "red", if not passed thenn "green" if same day then "yellow". How can I do this? thanks ! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
I want to change the cell format (color) based on a calc
Assuming the due date is in cell A1...
Select cell A1 Goto the menu FormatConditional Formatting Select the Formula Is option Condition 1 (due date expired - RED) Enter this formula in the little box on the right: =AND(COUNT(A1),A1<TODAY()) Click the Format button Select the Patterns tab Select a nice shade of REDOK Click the Add button Condition 2 (due date is today - YELLOW) Formula Is: =A1=TODAY() Click the Format button Select the Patterns tab Select a nice shade of YELLOWOK Click the Add button Condition 3 (due date is in the future - GREEN) Formula Is: =AND(COUNT(A1),A1TODAY()) Click the Format button Select the Patterns tab Select a nice shade of GREEN OK out -- Biff Microsoft Excel MVP "mtnmanus" wrote in message ... I have a spreadsheet with due dates and current date - I want to change the status on those tasks based on calculation of due date against current date. If due date has passed - I want to turn cell "red", if not passed thenn "green" if same day then "yellow". How can I do this? thanks ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change tab color based on current color of a cell | Excel Discussion (Misc queries) | |||
Conditional format: change row color based on cell value | Excel Discussion (Misc queries) | |||
Can you change the color of one cell based on the color of another | Excel Discussion (Misc queries) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
Change tab color based on a cell value | Excel Discussion (Misc queries) |