Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-09-2014, 03:42 AM
teza2k06 teza2k06 is offline Date Conditional Formatting Windows 7 64bit Date Conditional Formatting Office 2010 32bit
Advanced Beginner
Date Conditional Formatting
 
Join Date: Feb 2013
Posts: 37
teza2k06 is on a distinguished road
Default Date Conditional Formatting

On my spreadsheet i have this Formula =TODAY() in cell AQ3 which links to cell E6 =COUNTIF(F$11:F$65536,"<"&AQ3)

The formula basically counts how many cells in Column F (from a certain point) are less than todays date



I have a conditional formatting set up so that any cell in Column F which is less than todays date <$AQ$3 will automatically highlight in a certain colour. The only problem that i have is all the cells i have selected for this conditional formatting, it also highlights the blank cells.

Is there a way where i can keep the conditional formatting so when the date is less than todays date it highlights the cell, but not the blank ones?

Any help will be grateful
Reply With Quote
  #2  
Old 08-09-2014, 09:58 AM
whatsup whatsup is offline Date Conditional Formatting Windows 7 64bit Date Conditional Formatting Office 2010 32bit
Competent Performer
 
Join Date: May 2014
Posts: 137
whatsup will become famous soon enough
Default

Hi

Choose as rule cell value between ---> 0.5 AND $AQ$3

Be aware: Cond. Formating slows down calculation significantly if applied to huge ranges.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Conditional Formatting Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Date Conditional Formatting Conditional formatting question based on cell date Cosmo Excel 2 04-08-2013 12:12 PM
conditional formatting otuatail Excel 1 06-06-2012 05:07 AM
Date Conditional Formatting Conditional Formatting. Laurie B. Excel 6 04-09-2012 05:01 PM
Conditional Formatting namedujour Excel 3 08-25-2011 01:46 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:14 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