Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I calculate 30, 60 90 days overdue from date invoiced | Excel Discussion (Misc queries) | |||
Apply green to current date, red to 2 days overdue and none if pai | Excel Worksheet Functions | |||
Excel - highlight colour of cell not showing except on preview | Excel Discussion (Misc queries) | |||
need an overdue date to highlight | Excel Discussion (Misc queries) | |||
Date Overdue function, Macro, or VBS | Excel Discussion (Misc queries) |