I am attempting to make a vehicle fleet maintenance workbook which contains 2 worksheets, on sheet2 I have many rows of vehicles details, 3 cells in each row have conditional formatting applied, enabling each of them to independently change to any of 3 colours (triggered by a vehicles proximity to different dates using the TODAY() function). On sheet1 I want to have a single corresponding column which will detect if any or all of the 3 cells in sheet2 have been "triggered" and display this by changing the cell colour. Phew...sorry if thats a bit long winded. I have little or no experience of VBA but hope there may be a formula I can utilise to help.

Many thanks in anticipation.