Conditional Formats

Hi!

A simple thought: you seem to be interested if the biggest value
occurring in your list is 100%.

If so, set your flag to show if max(A1:A200)=100%. (Check: I don't know
how you have calculated/formatted the 100%: it could just be =1)

Alf


---
Message posted from http://www.ExcelForum.com/

Sorry, I should have made that clear. In my column I have 5 cells of
percentages. Each individual percentage hase a conditional format on
it. At the bottom I have an autosum to add up the cells with the
percentages wich always will equal 100%. I want to put a conditional
format on the autosum (of 100%) to change to red only if one of the
percents in the autosum turns red based on my conditional format.


---
Message posted from http://www.ExcelForum.com/

Hi!

Given the small no. of cells to check the following would do it.
Bigger numbers would need something different.

Suppose the 5 data cells are A1 to A5. Sum is in A6.
Suppose further that A1 goes red if its value is x1 and likewise
A2 with x2, A3 with x4 etc.

Then use conditional formatting with the following condition:

formula is .......... =or(A1x1, A2x2, A3x3, A4x4, A5x5)

Alf


---
Message posted from http://www.ExcelForum.com/

It took some playing around with, but it works exactly how I wanted.



Thanks for all your help Alf


---
Message posted from http://www.ExcelForum.com/