- Jun 15, 2012
- 1,044
- 21
- 19,615
Hey everyone!
I am curently trying to create a spreadsheet at work which allows users to inut a date, but if that date is outside of a specified range I need it to change colour. I cannot post the specifics of this work due to legal reasons, but below is an example:
Lets say all work needs to be completed by the 01/01/2013, just for arguments sake. If Someone enters a completion date (Using the format DD/WW/YYYY) that is before this, or on this date, that cell needs to turn green. If a date is entered after this date, the cell needs to turn red. If there is no data in the cell, then the cell should be yelow.
Thanks in advance for your help!
P.S. I need this work doing today, so a quick response would be greatly appreciated!
I am curently trying to create a spreadsheet at work which allows users to inut a date, but if that date is outside of a specified range I need it to change colour. I cannot post the specifics of this work due to legal reasons, but below is an example:
Lets say all work needs to be completed by the 01/01/2013, just for arguments sake. If Someone enters a completion date (Using the format DD/WW/YYYY) that is before this, or on this date, that cell needs to turn green. If a date is entered after this date, the cell needs to turn red. If there is no data in the cell, then the cell should be yelow.
Thanks in advance for your help!
P.S. I need this work doing today, so a quick response would be greatly appreciated!
Facebook
Twitter
Instagram