Conditional Format If this happens!

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.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
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
 
Last edited:
Upvote 0
Last edited:
Upvote 0
Hi,

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

https://drive.google.com/open?id=1KhqOmCtzYf6Q9-fo1M_HsPduxGtpudVY

https://drive.google.com/open?id=1N3ucyDzJH6JbQ1UlGE7ngiFycSJRMLDt

https://drive.google.com/open?id=1iCGl1Y7vs54AUCPjUSVmRafdEIVnIWdM

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!
 
Upvote 0
Hi, as @Fluff wrote in #2 you’ll need to select all three rows so that conditional formatting works for all the 3 rows
 
Upvote 0
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
 
Last edited:
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,238
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top