highlight cell with colour if date overdue

H

Harvey

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

Cobditional Formatting Rows based on dates in action plan. 0
Is it possible to edit colours already saved as part of a custom theme? 0
Using colour conditional formatting to show whether due date has past 0
Need Help with a VBA subroutine 0
Maintaining Background Colours of Tasks of a Subproject in the Master Project File? 0
Complex Count Query 0
Sharing a worksheet/tracking payment dates 1
Project 2000 - Change colour of cell text based on formula 3

Top