Question related to Conditional formatting

Super Contributor

Hello Everyone,

Can you please show with example of Conditional formatting -


Let say - 

1 --> Highlight the cell which is less than 30 days from the today's date?


2 --> Highlight cell which is less than 30 days of specific date(let say : 13-March-2022)


Please help..??


1 Reply


Here is an example file, you just have to adjust the condition to your liking.


Use conditional formatting to highlight information

If you'd like to watch videos of these techniques, see Video: Conditionally format text and Video: Conditionally format dates.


Hope I could help you with these information / links.



I know I don't know anything (Socrates)