Previous Topic Next Topic

Excel conditional formatting

Closed
Kawshy - Feb 23, 2010 at 04:01 AM
rizvisa1 Posts 4478 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
Related:

1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
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
0

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses