Conditional Formats

  • Thread starter Thread starter Et3rnal
  • Start date Start date
E

Et3rnal

I have a colum with percents that have a conditional format on each one
The conditional format is set to turn red if it is outside th
specified range, or stay green if it is acceptable. The cel
undernieth this range of percents equals 100%. Is it possible to put
conditional format on the cell that equals 100%, that if any of th
above percents are red, then the 100% will turn red as well??? Or eve
lets say a picture (circle) beside my 100% that will change with th
above condition??


Thank
 
Hi!

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

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

Al
 
Sorry, I should have made that clear. In my column I have 5 cells o
percentages. Each individual percentage hase a conditional format o
it. At the bottom I have an autosum to add up the cells with th
percentages wich always will equal 100%. I want to put a conditiona
format on the autosum (of 100%) to change to red only if one of th
percents in the autosum turns red based on my conditional format
 
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(A1>x1, A2>x2, A3>x3, A4>x4, A5>x5)

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



Thanks for all your help Al
 
Back
Top