Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Sorry, VBA.. not VRB :)
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting two colors in the same cell | Excel Discussion (Misc queries) | |||
Cond. Formatting, Mod(Row) and cell conditions | Excel Discussion (Misc queries) | |||
Cond. formatting, based on other cell values? | Excel Discussion (Misc queries) | |||
Cond. Formatting; If Cell B6 or B7 is blank I want Cell D12 to be | Excel Discussion (Misc queries) | |||
cond formatting ? | Excel Worksheet Functions |