# Thread: Conditional Format If this happens! Thanks: 0 Likes: 0

1. ## Conditional Format If this happens!

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!

U.S.

2. ## Re: Conditional Format If this happens!

Select the rows you want it to work on & use
=\$Q12< MIN(\$R12:S\$12)
Where row12 is the first row in the applies range

3. ## Re: Conditional Format If this happens!

Hi,

This should work, I have applied the formula in Column R selecting all 3 R-S-T Columns:

your formula should work as @Fluff has given above. Alternate formula would be:
=AND(\$R1<\$S1,\$R1<\$T1)

4. ## Re: Conditional Format If this happens!

Originally Posted by Aryatect
Hi,

This should work, I have applied the formula in Column R selecting all 3 R-S-T Columns:

your formula should work as @Fluff has given above. Alternate formula would be:
=AND(\$R1<\$S1,\$R1<\$T1)
Thanks Aryatect! great examples pics! works fantastic ... however, the only issue is that it will highlight just a single cell of the three cells. I need it to highlight all three cells ONLY if the first cell is LOWER that the other two cells.

Any ideas? Thanks!

5. ## Re: Conditional Format If this happens!

The conditional format formula will also NOT copy down the row. It keeps just that first cells formula all the way down!

6. ## Re: Conditional Format If this happens!

Hi, as @Fluff wrote in #2 you’ll need to select all three rows so that conditional formatting works for all the 3 rows

7. ## Re: Conditional Format If this happens!

With the formula from post#2 I get

Excel 2016 (Windows) 32 bit
QRS
1291219
139819
1491219
159122
1691219
17151219
1862015
197511
201019
2191219

VBAinputs

Where the applies to range is Q12:S21

8. ## Re: Conditional Format If this happens!

I got it figured out guys! Here is the other step that needs to be included in the formula.

=AND(\$Q6<\$R6,\$Q6<\$S6,\$R6<\$S6)

It seems you can't formula copy all the rows at one time.
I did however copy row by row individually and that did work!

Thanks for all the input fellas! Much Appreciated and have a great weekend!

Regards,
U.S.