Conditional Formatting with more than 3 arguments.

**ammorford** · 03-01-2012, 11:59 AM

I have a spreadsheet with all of the purchasing data loaded into it. For each given item at a specific quantity, it pulls the minimum cost from each of my supplier charts located on separate pages. in a nearby chart, which is the same size/shape etc., I have an (IF) logic function that reads the (MIN) value pulled previously, and spits out the name of the supplier from which the value originates. I then have conditional formatting in place to color code it for easy reference.

My question is as follows: In my initial chart (MIN function result values) is there a way to pull the conditional formatting (background color specifically)from my IF chart given that each cell has a separate value?

To rephrase, if Cell A1 pulls from supplier KEN, can I make the background color of cell AI match the conditional formatting background from my IF chart? Any answers or help would be appreciated...I've been working on this puzzle all day, and i really don't want to do it manually each time I update pricing...

**hensucker** · 03-02-2012, 12:17 PM

Your title doesnt really match your question, kind of misleading you ask for more than 3 conditional formatting statement, possibly in the same cell. For this you would have to switch to VBA.
Now my suggestion is to set all the conditional formats then colour your charts to match the formatting, as reading your chart for a specific colour becomes next to impossible.
This might get you started with mutiple formatting:

Please Login or Register  to view this content.

Good Luck!

Let Us Know.

**Palmetto** · 03-03-2012, 09:26 PM

To rephrase, if Cell A1 pulls from supplier KEN, can I make the background color of cell AI match the conditional formatting background from my IF chart?

You will have to use the same criteria for the Conditional Format in cell A1 (supplier KEN) in your "IF chart".

Generally, it is more helpful to upload sample workbooks (dummy data, exact structure) to provide context and data to help with the solution.

**Palmetto** · 03-03-2012, 09:26 PM

To rephrase, if Cell A1 pulls from supplier KEN, can I make the background color of cell AI match the conditional formatting background from my IF chart?

You will have to use the same criteria for the Conditional Format in cell A1 (supplier KEN) in your "IF chart".

Generally, it is more helpful to upload sample workbooks (dummy data, exact structure) to provide context and data to help with the solution.