highlight cell with colour if date overdue
 

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

highlight cell with colour if date overdue
 

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




In article ,
Harvey wrote:

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

highlight cell with colour if date overdue
 

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)

"Harvey" wrote in message
...
can anyone tell me please how do i highlight a cell in a spreadsheet with
colour if date overdue

highlight cell with colour if date overdue
 

Use formatconditional 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




"Harvey" wrote in message
...
can anyone tell me please how do i highlight a cell in a spreadsheet with
colour if date overdue

highlight cell with colour if date overdue
 

Oops, don't how that happened, should be TODAY()


--


Regards,


Peo Sjoblom


"Peo Sjoblom" wrote in message
...
Use formatconditional 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




"Harvey" wrote in message
...
can anyone tell me please how do i highlight a cell in a spreadsheet
with
colour if date overdue