ExcelBanter - Conditional formating

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

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

- - Conditional formating (https://www.excelbanter.com/excel-discussion-misc-queries/205755-conditional-formating.html)

nativeutah

Conditional formating

I run a report for employees that have review dates that are due, I would
like the past due dates to change colors so I see them right away, what
formula would I use.

Sheeloo[_2_]

Conditional formating

If due date is in column B then use
B1today()
as the condition for conditional formatting..

"nativeutah" wrote:

I run a report for employees that have review dates that are due, I would
like the past due dates to change colors so I see them right away, what
formula would I use.

All times are GMT +1. The time now is 03:29 AM.