Formula for Multiple Conditions

  TonyV 15:22 14 Nov 2012


If my understanding is right, you need the formula =IF($E$2="No","No","") in cells F2 to J2. This will put a blank or No in the cells. Then to Highlight those cells, (F2 to J2), select them all and Conditionally Format them to give the background colour you desire.

Hopefully that is what you are looking for.



This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Samsung Galaxy Book 2: Release date, price and specs

This First Man soundtrack vinyl cover art is exquisitely composed

How to watch Apple’s October 2018 iPad launch

Meilleurs VPN (2018)