Rules/conditional formatting

Hi,

 

I am doing a spreadsheet and I need one column (D) to go red and say “Not Ready” if any of the 7 other cells (E to K) in that row are red (already allocated some conditional formatting). I also need that column (D) to go green and say “Ready” if those 7 other cells in that row are either blank, yellow, or blue. The conditional formatting applies to dates and it changes depending on if that date is expired, 30 days out, or 60 days out.

 

I hope that makes sense.

 

Thank you!

By: Rochelle

Leave a Reply

Your email address will not be published. Required fields are marked *