Y
yatta1337
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.
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.
