Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Matching Cell Colors (Cond. Formatting)

Here's my situation, I have 3 columns (G, H, and I) which have
expiration dates and they use conditional formatting to adjust the
color of the cell based on how close the date is (either past - red,
expires in 30 days - yellow, or expires in more than 30 days - green).
So for a particular row, there could be one good date (green) and two
expired (red), or all one color, etc... I would like to have excel
automatically change the cell color for the cell in Column A to match
the most severe of the dates from G, H and I. So if any of the G, H or
I dates had expired, the cell in column A would show up red. If there
were 2 good dates (green) and one getting ready to expire (yellow), the
cell in column A would show up yellow. I've been trying to research
around and have found some information on VRB and whatnot, but I'm not
quite sure how I would go about resolving this issue. Any help would
be greatly appreciated.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Matching Cell Colors (Cond. Formatting)

Sorry, VBA.. not VRB :)

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
Formatting two colors in the same cell Mamede Excel Discussion (Misc queries) 9 April 5th 23 01:04 PM
Cond. Formatting, Mod(Row) and cell conditions wynand Excel Discussion (Misc queries) 2 May 28th 10 10:53 AM
Cond. formatting, based on other cell values? GD Excel Discussion (Misc queries) 3 February 7th 09 07:26 PM
Cond. Formatting; If Cell B6 or B7 is blank I want Cell D12 to be Dr. Darrell Excel Discussion (Misc queries) 5 December 28th 08 08:54 PM
cond formatting ? Brian Excel Worksheet Functions 2 July 11th 06 04:12 PM


All times are GMT +1. The time now is 08:23 PM.

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"