Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet and am looking for some assistance to make a conditional
format to produce the following: I will be entering dates in a column and then between 1 and 7 days an adjacent cell will show green and the words "Processing" Between 8 days and 14 days the adjacent cell should turn yellow and show "Check Status" If the period exceeds 14days then the cell should turn red and show the word "Overdue" I have tried a number of the responses in the threads but just cannot seem to get the proper result. Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Change cell colour by date | New Users to Excel | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
cell colour change | Excel Worksheet Functions | |||
how to change the state of a number in a cell from negative to po. | Excel Discussion (Misc queries) |