Previous Topic Next Topic

Excel conditional formatting

Closed
Kawshy - 23 Feb 2010 à 04:01
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 23 Feb 2010 à 04:02
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

Réponse 1 / 1
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
23 Feb 2010 à 04:02
sure, use today() function instead of hard coded value. If you want some thing 2 days back from today, have it like today()-2

Similar discussions

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

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

1 response
Conditional Format Cells Based on Another Cell and Own Cell
Elaine -
x -

1 response
Conditional Formatting - highlight overdue dates
TanyaRT -
TanyaRT -

2 responses