| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
current date it should intimate cheques due by colour change
i had entered the postdated cheques in excel it should give a colour change
the cheques when the cheques are due on the particulair date when it is opened. I want to know about the formula. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
current date it should intimate cheques due by colour change
Format/ Conditional Formatting/ Cell value is: less than or equal to:
=today() or Cell value is: less than or equal to: =today(), if you want them to show only on that day or Cell value is: greater than: =today(), if you want to highlight the post-dated ones. -- David Biddulph "mas" wrote in message ... i had entered the postdated cheques in excel it should give a colour change the cheques when the cheques are due on the particulair date when it is opened. I want to know about the formula. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
| Change cell colour by date | New Users to Excel | |||
| Can I program Excel cells to change colour at a set date? | Excel Discussion (Misc queries) | |||
| Having a due date flag in a different colour 30 days from current. | Excel Worksheet Functions | |||
Linear Mode
