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

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