Liz has attended:
SharePoint course
Conditional formatting
I want to use Conditional Formatting to make a date go red when it is today or in the past, but remain black for dates in the future.
I have inserted the following rule:
Format only cells that contain Cell Value less than or equal to ="TODAY" and I have selected red text.
Whatever date I enter goes red.
Please help
RE: conditional formatting
Hello Liz,
Thank you for your question regarding Excel conditional formantting.
All our Excel trainers are delivering training today, but will be able to respond on Monday.
Kind regards,
Richard
RE: conditional formatting
Hi Liz,
You have followed exactly the right steps for your formatting, it could be just that you've made a small mistake when using the today function.
Try this: Format cells that contain cell value less than or equal to =TODAY()
Remember to include the open and close bracket and there's no need to use speechmarks.
This should then give you the result you're looking for, let me know if you're still having trouble.
Kind Regards,
Sarah Reid
Excel Trainer
