current date it should intimate cheques due by colour change

M

mas

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.
 
D

David Biddulph

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.
 

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

Cheque Print 0
Printing Cheque of Different sizes from the same Worksheet 9
Table Design - stuck! 7
autofill colour based on date entered 4
Can't save my Office documents (after computer rebuild and reauthorization) 0
help needed in worksheet function 1
Using colour conditional formatting to show whether due date has past 0
Using CF to change colour in cell based on date? 4

Top