Formula for Multiple Conditions

  daddy3108 19:49 PM 13 Nov 12
Locked

Hi,

Please can someone help me? I need to write a formula based on the response for two cells, but am having problems joining them. The first part of the formula works, but I can't seem to get the end of it.

In Cell D2 is called SDP1, Cell E2 is called SDP2. If yes is entered in E2, then nothing needs happen. If however, No is entered then the cells F2 - J2 needs to be highlighted; with No as the result not FALSE.

This is the first part of the formula: =IF($D$2="Yes","Yes"),can't seem to get this bit working?????

I hope that this makes sense and that someone can help me.

Many thanks :0/

  Woolwell 21:22 PM 13 Nov 12

Having trouble fully understanding this but shouldn't the formula be =IF($D$2="Yes","Yes","No") which returns NO if Yes isn't inserted in D2.

  TonyV 15:22 PM 14 Nov 12

daddy308

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.

Cheers

TonyV

  daddy3108 20:35 PM 14 Nov 12

Thanks for the responses guys.

Tony yours worked a treat - Thank you! xx

  TonyV 21:26 PM 14 Nov 12

daddy3108

Glad it worked out OK.

TonyV

Advertisement

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

14 best budget laptops of 2015: best budget laptops reviews - best cheap laptops - best bargain…

1995-2015: How technology has changed the world in 20 years

Animated film of Raymond Briggs' Ethel and Ernest ramps up production

From Antennagate to Yellowgate: The 10 worst Apple scandals (and why they were blown out of proport)…