LinkBack URL
About LinkBacks
Need help with conditional formatting for the following: IF the sum of a2 thru a6 is > a1, format cells a2 thru a6 that contain numbers (with the ‘bad style’ (or pink fill with red font). Is this even possible?
Need help with conditional formatting for the following: IF the sum of a2 thru a6 is > a1, format cells a2 thru a6 that contain numbers (with the ‘bad style’ (or pink fill with red font). Is this even possible?
Yes of course it is possible.
In A2 conditional format formula:
=SUM(A2:A6)>A1
Format the fill as you need.
Then edit the rule and change the range to the other cells.
I hope that helps,
XJ
Select cells A2:A6 and use the formulaChoose your colours as you wish.Formula:
Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
I see how this works! now the next step - what if I only want to format the cells a2 - a6 that actually contain a value?
=and(a2<>"",sum($a$2:$a$6)>$a$1)
OK, that would be the formula:Formula:Please Login or Register to view this content.
Note that it is $A2, NOT $A$2
Removed thanks
Last edited by xjohnson; 11-28-2018 at 05:10 PM.
You rock! Thank you so very much!!!
@xjohnsonNot sure who that is aimed at.You win
We seem to have provided much the same solutions. However, the first stage can be completed in one step by selecting the whole range and using the formula for the first cell, rather than copying and pasting the CF. Second part, I just prefer to use absolute references unless the CF is being dragged across columns.
@megmad: You're welcome. Thanks for the rep.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks