Conditional Format Based on Numerous Columns

ohhaykfrankk

New member
Joined
Jan 29, 2017
Messages
33
Reaction score
0
Points
0
Excel Version(s)
2010
Hello all! I'm looking for some sort of formula, macro, anything.
This is an example of my chart.
A D E F G H I J
Text # #
Text # #

Right now, I have it set so that D-J will highlight if the number is higher than a different box (per column), for this example we can use K1-K7.

I was wondering if there was a way I could highlight the text in column A if BOTH numbers are higher than their K boxes, that way I can tell, because right now, one number in a row is highlighted but it's still useless to me because I need them both highlighted so I still have to read through them.

If this makes any sense, please give it a try. If not, I can try to explain better or post the chart. Thanks in advanced!
 
Please post a sample sheet with some data and expected results. Thanks
 
Thanks! This is a sample of my current results based on my conditional formatting. I've written my expected results. It's really just getting both columns to pay attention to each other and not just themselves. Selfish.
View attachment excel test.xlsx
 
I do not understand you completely, but try Conditional Formatting the formula below to apply to column 'A'
Code:
=AND(B2>$G$6;C2>$G$7)
 
Not sure if it's important, I would use $B2 and $C2
 
I can't believe it was that easy. I'm a little embarrassed.

Thank you both, this works perfectly!
 
Back
Top