Home Menu

Menu


ExcelBanter » Excel Newsgroups » Excel Worksheet Functions > Formating a row based on one cell's date
Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
  
Posts: 19
Default
I made a change to the "applies to" field now everything works perfectly....I have more last question. If I wanted to use the same rule but only highlight rows that had a status other than 'CLOSED' how would I go about it?
Reply With QuoteReply With Quote
  #2   Report Post  
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by Tee51 View Post
I made a change to the "applies to" field now everything works perfectly....I have more last question. If I wanted to use the same rule but only highlight rows that had a status other than 'CLOSED' how would I go about it?
Amend the same formula, to include it. You'd need to use AND for that.

=AND($A1=today()-6,F1<"Closed")

Change F to whichever column your "Closed" is recorded in if not F.

Hope that helps.
Reply With QuoteReply With Quote
  #3   Report Post  
Junior Member
  
Posts: 19
Default
Quote:
Originally Posted by Spencer101 View Post
Amend the same formula, to include it. You'd need to use AND for that.

=AND($A1=today()-6,F1<"Closed")

Change F to whichever column your "Closed" is recorded in if not F.

Hope that helps.
When using =AND($A1=today()-6,F1<"Closed"), the format changes...see attached.
Reply With QuoteReply With Quote
  #4   Report Post  
Junior Member
  
Posts: 19
Default
Quote:
Originally Posted by Tee51 View Post
When using =AND($A1=today()-6,F1<"Closed"), the format changes...see attached.
File attached
Attached Files
File Type: zip Copy of Tee51 Example.zip (5.8 KB, 35 views)
Reply With QuoteReply With Quote
  #5   Report Post  
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by Tee51 View Post
File attached
Sorry, my bad. Put a $ before the F too...
Reply With QuoteReply With Quote
  #6   Report Post  
Junior Member
  
Posts: 19
Default
Quote:
Originally Posted by Spencer101 View Post
Sorry, my bad. Put a $ before the F too...
The current formula is highlighting 7 days before and after today. Is there anyway to highlight only 7 days before?
Reply With QuoteReply With Quote
  #7   Report Post  
Senior Member
  
Posts: 663
Default
Quote:
Originally Posted by Tee51 View Post
The current formula is highlighting 7 days before and after today. Is there anyway to highlight only 7 days before?
Just add another condition to the AND....

=AND($A1=TODAY()-6,$A1<=TODAY(),$F1<"Closed")
Reply With QuoteReply With Quote
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formating based on Date Kimti Excel Discussion (Misc queries) 7 March 8th 10 04:18 AM
Conditional Formating based on Date Flcnmech Excel Worksheet Functions 1 February 14th 08 08:21 PM
Conditional Formating Based on Date Roy Excel Discussion (Misc queries) 5 June 7th 06 04:49 PM
Change value based on another cell's value mainemike Excel Discussion (Misc queries) 1 March 7th 06 06:36 PM
Conditional Formating for a cell based on another cell's value steve-o Excel Discussion (Misc queries) 1 October 6th 05 09:50 PM


All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Contact Us ExcelBanter forum home Privacy Statement