Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Tiegris
 
Posts: n/a
Default 30 Day Aging Report Using Conditional Formating

I need to set up a row to highlight as a certain color when it reaches the
over thirty day mark in it's dated cell, and also highlight with an alternate
color for rows that have reached the thirty day mark. The problem I am
having is that this needs to be done by the week and not day. For ex. If a
row reaches the thirty day mark it can be any date within that week. I know
that conditional formating can do this for me, but how?
--
JW
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 csfrolich Excel Discussion (Misc queries) 2 January 17th 05 02:07 PM
Conditional Formating Aviator Excel Discussion (Misc queries) 1 January 12th 05 05:37 PM
Can i carry out more than 3 conditional formating Queries? how? andy Excel Discussion (Misc queries) 2 December 20th 04 04:49 PM
How to change an entire row using conditional formating John Edwards Excel Discussion (Misc queries) 2 December 9th 04 05:41 PM
HELP ME PLEASE!! CONDITIONAL FORMATING HIGHLIGHTING CELLS. ANDREW_B Excel Discussion (Misc queries) 1 December 2nd 04 04:12 PM


All times are GMT +1. The time now is 12:23 AM.

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

About Us

"It's about Microsoft Excel"