Ultimate Selector
Board Regular
- Joined
- Dec 15, 2013
- Messages
- 153
Let's say I have 3 columns with 3 numbers in them.
Example ... Columns R-S-T ... In these cells are the following numbers.
9-12-19
Now what I want to do is highlight the whole row of all 3 numbers IF: the very first number (9)
is lower than both of the other two. (12-19)
I can get it to work if I Conditionally Format a single row at a time.
I can't get it to copy (paint brush) the format down the Column of the sheet.
It just copies the very first cell format down the sheet.
Here is my current formula: =$Q12<$R12:S$12
Any formula that you have to help me out is very much Appreciated!
Thanks in advance!!
U.S.
Example ... Columns R-S-T ... In these cells are the following numbers.
9-12-19
Now what I want to do is highlight the whole row of all 3 numbers IF: the very first number (9)
is lower than both of the other two. (12-19)
I can get it to work if I Conditionally Format a single row at a time.
I can't get it to copy (paint brush) the format down the Column of the sheet.
It just copies the very first cell format down the sheet.
Here is my current formula: =$Q12<$R12:S$12
Any formula that you have to help me out is very much Appreciated!
Thanks in advance!!
U.S.