ExcelBanter - Conditional formatting

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Conditional formatting (https://www.excelbanter.com/excel-programming/314186-conditional-formatting.html)

vdefilippo

Conditional formatting

Is it possible to format a cell, that contains a date, to change color after
30 days have passed since that date?

Grey Newt[_4_]

Conditional formatting

Yes
Using the formula facility in Conditional Formatting
If your date is in C4, then.......

Formula is.. =TODAY()-C430

then click the Format button and select your formatting for when this
condition is true

"vdefilippo" wrote:

Is it possible to format a cell, that contains a date, to change color after
30 days have passed since that date?

All times are GMT +1. The time now is 05:07 AM.