Conditional formatting based on other conditional formatting

Closed
MissDefy - Jan 4, 2015 at 10:04 PM
I have several coloumns in a spreadsheet, 3 of which which contain dates, and these have conditional formatting to show if that date has expired or is current. (ie. the font turns red if it is due within 14 days, and if the date is today or has passed the font turns red & the cell turns orange). What I need to do next is, in column A, I need to show if teh item is current or not, by colouring the cell green if it's good, or turning it ornage if one of the dates is today or has passed.

What conditioanl formatting do I need to use to make the cells in column A automatically turn orange, if the font in the columns containing dates turns red?