Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formula for Dates and CF Colour then convert to Text
Hi,
Part 1 - Although I can do the CF on the cell, I am looking for a formula based on the following: 1. Date entered is from Today up 7 Days - My CF will format cell to Green 2. Date entered is between 8 days and 14 days - CF will format Amber 3. Date entered is greater than 14 days (15?) - CF will format Red My current formula's in CF based on: Condition 1 - Formula is: =IF(D4<"",D4TODAY()-7) Condition 2 - Formula is: =AND(D4<"",D4TODAY()-14) Condition 3 - Formula is: =AND(D4<"",D4TODAY()-600) -600 was picked only because I have no dates longer than that period of days. Part 2 - Is it then possible, that when the CF changes the cell to the appropriate colour, can Text be entered into the next cell to actually say Red, Amber or Green and all this updates as each date passes. Reason for CF colour and then Text in next cell is that I use a COUNTIF formula to read the colours as text as couldn't get a colour count on cells despite many differing attempts. Thanks Craig |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert text to dates | Excel Discussion (Misc queries) | |||
How do I convert dates stored as dates to text? | Excel Discussion (Misc queries) | |||
Convert text dates | Excel Discussion (Misc queries) | |||
Convert Dates to text | Excel Discussion (Misc queries) | |||
Convert text to dates | Excel Worksheet Functions |