Superbaker
IS-IT--Management
I currently have a spreasheet where I used conditional formatting to hightlight dates that are older than the current date. The spreadsheet keeps track of insurance certificates and any certificates that have expired.
It says:
if cell value is less than =NOW() turn the text red.
This has been working fine but now they want to have the certifcates change color 1 month before they are up. I tried adding change it to
if cell value is less than =NOW()+30 turn the text red.
This didnt seem to work. Any ideas on how to make this happen
Thanks
It says:
if cell value is less than =NOW() turn the text red.
This has been working fine but now they want to have the certifcates change color 1 month before they are up. I tried adding change it to
if cell value is less than =NOW()+30 turn the text red.
This didnt seem to work. Any ideas on how to make this happen
Thanks