| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting or formulae to show elapsed dates
I have a large sheet showing dates of expiry. I want to see at a glance
which have elapsed. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting or formulae to show elapsed dates
Assuming date in B2 try the following:
=IF((B2-TODAY()<0),"Expired", "OK") "Jo" wrote: I have a large sheet showing dates of expiry. I want to see at a glance which have elapsed. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting or formulae to show elapsed dates
Brilliant! Thanks JC
"JC" wrote: Assuming date in B2 try the following: =IF((B2-TODAY()<0),"Expired", "OK") "Jo" wrote: I have a large sheet showing dates of expiry. I want to see at a glance which have elapsed. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
conditional formatting or formulae to show elapsed dates
=IF(TODAY()B2,"Expired","OK")
"Jo" wrote: I have a large sheet showing dates of expiry. I want to see at a glance which have elapsed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine Conditional Formatting Rules formulae | Excel Discussion (Misc queries) | |||
| Conditional formate:show by color when expiration dates are overdu | Excel Discussion (Misc queries) | |||
| Nested functions in conditional formatting formulae | Excel Discussion (Misc queries) | |||
| show elapsed time ? | Excel Discussion (Misc queries) | |||
| Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) | |||
Linear Mode
