more than 3 conditional formats

  peug417 23:11 06 Sep 03

I am trying to conditionaly format a cell, conditional format allows mr 3 conditions but i need more. Is it possible to have more than one in each condition?

ie = d4="james","Jones","John". If any of these names appear in that cell i need iy to change colour.

  madPentium 23:25 06 Sep 03

can you please state which application you are refering to?

  peug417 23:30 06 Sep 03

I am using Excel speadsheet and need to format a cell if any one of six names appear in it.

  tbh72 00:07 07 Sep 03

peug417 - I have just looked with interest at Excel. You can specify upto 3 condition's, but according to the help file it is possible to use default setting's as one condition giving a maximum of 4 condition's.

Vog is the excel man, I am quite sure on his return if it's possible ( I think it is using formulas / instead of menu bar feature ) he will be able to give you clearer instructions to achieve this.

Sorry I couldn't be more help!!

  MAJ 00:46 07 Sep 03

Here's the way I would do it, It will not be as pretty as VOG's but it should work for you.

In the conditional formatting box, choose "Formula is" Then enter the formula:


You see I have used the cell A4 and only 4 names but I think you get the idea, peug417.

  MAJ 00:48 07 Sep 03

don't forget to choose your conditioning at the bottom of the condional formatting box.

  VoG II 09:01 07 Sep 03

That is exactly how I would do it.

  peug417 09:52 07 Sep 03

Thank you very much for that advice, it worked a perfectly and has saved me a few more grey hairs.
I was trying every combination of IFOR IFAND and obviously getting knowhere.

  MAJ 12:11 07 Sep 03

I'm glad it worked for you, peug417.

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

Nintendo Switch (Nintendo NX) release date, price, specs and preview trailer: Codename NX console…

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

8 things designers (and brands) need to know about the modern woman

How to speed up a slow Mac: 19 great tips to make an iMac, MacBook or Mac mini run faster | Speed…