try this again - cONDITIONAL FORMATTING HELP NEEDED

[danman]

Lemme try this again please:

I now have 3 identical size sheets of data from 3 suppliers.

I wish to compare the cell data in the 3 sheets...and create a ne
sheet which shows the minimum value and places it in the respectiv
cell in the new sheet


eg. compare sheet 1 cell c5 ,, with sheet 2 cell c5 , with sheet 3 cel
c5....and choose the lowest value and print in new sheet 4 cell c5.


ALSO , sheet 1 is green font, sheet 2 is red font, sheet 3 is blu
font.....I want the new cell in sheet 4 to use the color from th
sheet which "donated" the minimum value


By doing this i can just look at the new sheet 4 and find the minimu
values, and the " cell colors" will tell me which supplier i shoul
choose

ALSO in case of "ties" ( minimum values) I would need a fourth color o
sheet 4 to indicate "multiple suppliers"

Sounds maybe lke i need a macro which i have little experience.an
advice or helps appreciated

thanks

DANMA

 

[Guest]

I'm not sure how you can have multiple C5's on one sheet, so I changed your references as follows--The first C5 is referred to as C5. The second C5 is referred to as C6, and the third C5 is referred to as C7. The cell that contains the formula and needs to be conditionally formatted is referred to as C8

This is what I would
Conditional formatting will only let you set up to 3 criteria, so I would set the default font in the cell that will contain the MIN function to Green. This means that if none of the Conditional Formatting criteria are met, you will know the value is from the first supplier
For your first Conditional Format change to "Formula is" and enter the following
=OR(AND(C8=C5,C8=C6),AND(C8=C5,C8=C7),AND(C8=C6,C8=C7)
Set the Format to the color you want the cell to be if more than one supplier has tied for the lowest number
Add a second condition and change it to "Formula Is" and enter the following
=(C8=C6
Set the color to Re
Add a third condition and change it to "Formula Is" and enter the following
=(C8=C7
Set the color to Blu

My first conditional formatting tries to account for all possible combinations of ties. I left out AND(C8=C5,C8=C6,C8=C7) because for that one to be TRUE, one of the three possibilities I did enter would also be TRUE.

t

----- danman > wrote: ----

Lemme try this again please

I now have 3 identical size sheets of data from 3 suppliers

I wish to compare the cell data in the 3 sheets...and create a ne
sheet which shows the minimum value and places it in the respectiv
cell in the new shee


eg. compare sheet 1 cell c5 ,, with sheet 2 cell c5 , with sheet 3 cel
c5....and choose the lowest value and print in new sheet 4 cell c5


ALSO , sheet 1 is green font, sheet 2 is red font, sheet 3 is blu
font.....I want the new cell in sheet 4 to use the color from th
sheet which "donated" the minimum valu


By doing this i can just look at the new sheet 4 and find the minimu
values, and the " cell colors" will tell me which supplier i shoul
choos

ALSO in case of "ties" ( minimum values) I would need a fourth color o
sheet 4 to indicate "multiple suppliers

Sounds maybe lke i need a macro which i have little experience.an
advice or helps appreciate

thank

DANMA

 

[danman]

THANKS TO ALL