Excel conditional formatting

Closed

Kawshy - Feb 23, 2010 at 04:01 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 23, 2010 at 04:02 AM

Hello,

I have an issue with conditional formating. For any chance is it possible to set a conditional format for a date that every day changes.

What I want to do es for excel to highlight automatically the deadline days at different dates accoring to the calandar in the computer.

Hope this makes sense and I hope you can help me.

Thank you

Excel conditional formatting
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Excel date format dd.mm.yyyy - Guide
Highlight cell if another cell contains any text ✓ - Excel Forum
Conditional format based on another cell containing text - Excel Forum
Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum

1 reply

Answer 1 / 1

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 23, 2010 at 04:02 AM

sure, use today() function instead of hard coded value. If you want some thing 2 days back from today, have it like today()-2

Subscribe To Our Newsletter!