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!
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!