highlight cell with colour if date overdue

G

Guest

can anyone tell me please how do i highlight a cell in a spreadsheet with
colour if date overdue
 
J

JE McGimpsey

And how exactly should XL determine that the date was overdue?

Take a look at Conditional Formatting in XL Help.

If, for instance, the due date is in A1 and the date is overdue if it's
in the past, select A1, choose Format/Conditional Formatting... and use
something like:

CF1: =A1<TODAY()
Format1: <patterns>/<color>
 
B

Bob Phillips

Look at conditional formula with a condition of Formula Is and a formula of
=A2<TODAY() and set the colour.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
P

Peo Sjoblom

Use format>conditional formatting, then formula is and

=A2<=DAY()

click format button and select red pattern or fonts and click OK twice

where A2 is the cell with the date you want to check if it is overdue
if it is 30 days from the date in A2 you can use

=A2+30<=TODAY()


--


Regards,


Peo Sjoblom
 

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 Excel due and overdue date colours 2
How do I highlight a cell when a date is overdue? 2
Conditional formatting, coloring the whole row 2
How do I set up automatic colour fill of a cell prompted by text? 1
how can i use cond formating to colour an entire column? 2
Ignore blank cells when calculating date for If, Then function 2
conditional formatting on date where today is > or = datevalue 3
Excel Typed text appears in wrong cell 0

Top