#1
|
|||
|
|||
Expired date
Could you help me. I would like when the invoice date has passed to highlight the full line but when the payout column has been paid to have no color. I attach an example to you. thank you |
#2
|
|||
|
|||
No need for code - a simple conditional formatting will do. (I colored the row for expired invoice, but you can change the formatting for row at will.)
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Counting non-expired dates | bbutl027 | Excel | 6 | 10-26-2015 06:37 PM |
one trial version expired. Can I .... | t-4-2 | Office | 3 | 12-06-2011 10:33 PM |
Expired Certificate message in Outlook 2007 | tupham | Outlook | 0 | 11-15-2011 02:50 PM |
OWA Certificate Expired Issue | ama | Outlook | 2 | 03-18-2011 02:11 PM |
how to display expired date in red (access) | iffy | Office | 5 | 01-16-2011 06:28 AM |