If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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/ |
#2
|
|||
|
|||
Conditional Formats
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/ |
#3
|
|||
|
|||
Conditional Formats
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/ |
#4
|
|||
|
|||
Conditional Formats
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/ |
Thread Tools | |
Display Modes | |
|
|