Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-08-2018, 03:35 AM
DIMI DIMI is offline Expired date Windows 7 32bit Expired date Office 2007
Advanced Beginner
Expired date
 
Join Date: Aug 2017
Posts: 37
DIMI is on a distinguished road
Default 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
Attached Files
File Type: xlsx INVOICE.xlsx (8.6 KB, 8 views)
Reply With Quote
  #2  
Old 07-08-2018, 05:44 AM
ArviLaanemets ArviLaanemets is offline Expired date Windows 8 Expired date Office 2016
Expert
 
Join Date: May 2017
Posts: 869
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

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.)
Attached Files
File Type: xlsx Invoice.xlsx (10.2 KB, 11 views)
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Expired date Counting non-expired dates bbutl027 Excel 6 10-26-2015 06:37 PM
Expired date 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
Expired date OWA Certificate Expired Issue ama Outlook 2 03-18-2011 02:11 PM
Expired date how to display expired date in red (access) iffy Office 5 01-16-2011 06:28 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft