ExcelBanter - Formuls to turn date red

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formuls to turn date red (https://www.excelbanter.com/excel-discussion-misc-queries/128002-formuls-turn-date-red.html)

John M.

Formuls to turn date red

Does anyone know how to take a cell with a date and compare with the clock on
the cumputer and turn the cell date Red if it is 1 or 2 months before the
computer date

Teethless mama

Formuls to turn date red

Conditional Formatting

=TODAY()-A1<=30

"John M." wrote:

Does anyone know how to take a cell with a date and compare with the clock on
the cumputer and turn the cell date Red if it is 1 or 2 months before the
computer date

All times are GMT +1. The time now is 10:14 PM.