View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_2_] Sheeloo[_2_] is offline
external usenet poster
 
Posts: 364
Default 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.