CF cell highlight based on another columns colour

Morning All,

Im working on a specific sheet for my company and I'm looking for some help regarding the final piece of the jigsaw for the sheet.

Basically I have a 'Summary' Tab and a 'Development' Tab and i need a cell on the Summary tab (G11) to highlight red and display 'Invoice reminders' when anything in the development tab column (J9 downwards) highlights in red. The column in the development tab has conditional formatting applied for 30 days after invoice is sent and I'm basically after a 1 cell alert on the summary page so other employees do not have to scroll through developments potentially missing stuff.

Apologies if this sounds a bit long winded but i didn't know how else to explain my problem :S

Any help is greatly appreciated.

Tone

You can't create CF base don color of other cell.

a) If you use CF for all other cells then you need to create color based on CRITERIA that you use for CF of other cell (not color itself)
b) use VBA

You can't create CF base don color of other cell.

a) If you use CF for all other cells then you need to create color based on CRITERIA that you use for CF of other cell (not color itself)
b) use VBA

thanks for your response. I shall look for another alternative