Hi I am trying to finalise the following database:
https://docs.google.com/spreadsheets/d/1bdCKfUvgyVU8Rjf3WqwNY69fgfTZN0oLpNNzpbe1VJI/edit#gid=1696971209 I am attempting that the following happens: What I would like to do is: Rules 3 Cell C to remain green when: there is no date entered into the cell and is less than cell B - 30 days There is a date entered into cell C which is equal or less than Cell B Rule 2 Cell C to go Amber when: Cell B date is within 30 days and no date has been entered Rules 1 Cell C to go Red when Date in Cell C is past Cell B date No date is entered in Cell C after the identified date in Cell B Hope someone can assist Thanks Graham -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
