Hello
I have a coumn of data say A1 to A4 and I want to apply conditional formatting so that if the percentage of the A1 is greather than 25% then formate red.
The formula to calculate the percentage is
=SUM(A1/SUM(A1:A4))
I'm not sure how to apply this straight to the numerics as conditional formatting without a seperate % column which I don't want.
Thanks
in conditional format
use a formula and put
=SUM(A1/SUM(A1:A4))>0.25
see example attached
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks for this. Is there any way of applying these custom rules to icon sets do you know?
Thanks
what do you want the icons to do
you can just have the values for red/amber/green
set to
Green %
Amber %
Red will be anything following amber
see attached
Sorry I should have been clearer but I'd like a red traffic light icon to appear if =SUM(A1/SUM(A1:A4)) greater than 25%
edit the icon set in conditional formatting
and instead of
RED >= 0.25 (25%)
then change the dropdown from
>=
to
>
then it wont be red when it is 25% exactly
is that what you meant - other wise its working as described - red > 25%
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks