Hi, i know how to do Conditional Formatting for Single Cell value = Specific text, however, i wan to do it for 2 Criteria. One Row and one column Criteria.
However, i keep do not get the result. Not sure y. Anyone can help?
Hi, i know how to do Conditional Formatting for Single Cell value = Specific text, however, i wan to do it for 2 Criteria. One Row and one column Criteria.
However, i keep do not get the result. Not sure y. Anyone can help?
EDIT - simple way posted by @davsth , so ignore mine
how about
=SUMIFS(C2,$B2,$K$2,C$1,$K$1)
i'm sure a simplier way is possible - just eludes me at the moment
sumproduct() will work as well
for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting
Highlight applicable range >>
C2:I10 - Change, reduce or extend the rows to meet your data range of rows
Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=SUMIFS(C2,$B2,$K$2,C$1,$K$1)
Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK
i suspect better ways to do this - I also tried sumproduct , which worked
Last edited by etaf; 03-19-2024 at 07:30 AM.
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.
it would be simpler as a countifs, but pretty much the same logic
=countifs($B2,$K$2,C$1,$K$1)
or even
=($B2=$K$2)*(C$1=$K$1)
@davsth
tried some of that type of thing - just had brain fade=($B2=$K$2)*(C$1=$K$1)
I knew there was a much simpler wayi'm sure a simpler way is possible - just eludes me at the moment
so ignore my post here
This works.
Select C2:I10. Formula for CF is
Formula:Please Login or Register to view this content.
Pl note
Array formula should be confirmed with Ctrl+Shift+Enter keys together.
If answere is satisfactory press * to add reputation.
Another formula
Formula:Please Login or Register to view this content.
Hi to all the expert out there. Thanks for all the suggestion. So glad i manage to find a solution.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks