ExcelBanter - 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.