Due Date condition

  • Thread starter Thread starter Ania
  • Start date Start date
A

Ania

hi,

I have a spreadsheet with column: Open/Closed and column:
Due Date. If Open/Close condition is "OPEN" and Due date
already passed, then I need to have red color
representation indicating late passed due date. Any input
is appreciated! Thanks!

~Ania
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel date conditions 2
Excel Excel due and overdue date colours 2
Conditional Formatting 5
Conditional Format - Due Dates - 2 questions (2nd posting) 2
Conditional Format over Date Range 3
conditional formula with date 6
I want to change the cell format (color) based on a calc 4
Calculating interest due on late loan payments 1

Back
Top