Excel 2010- Copy Conditional Formating from a row with 4 columns to all rows

[dudeshane01]

Hi
I have searched a lot for other replies before posting.
The first row with 4 columns of data in attached sheet is conditionally formatted.
The minimum value out of 4 columns is highlighted. (Prices of same product from different suppliers)
I want to copy the conditional formatting from first row of data to all rows below it.
I do not want to copy one by one as for big sheet it is time consuming.
Kindly see if you can copy by dragging or pasting formulas from first row.
I am using excel 2010.

[FDibbins]

Hi and welcome to the forum

open CF, click on the rule, in the "applies to" change the range to whatever your larger range will be

[dudeshane01]

Hi FDibbins
Thanks and I tried the suggestion.
But that does not result in minimum value of each row being highlighted.
Instead it takes whole data as range and highlights only one cell.
Attached is the updated file.
Could you suggest again how can I highlight the minimum value in each row instead?
Capture.JPG

[FDibbins]

OK try this...

1st, delete the rule you have there, then create a new rule - Use Formula
"applies to" entire range
=C3=MIN($C3:$F3)

[dudeshane01]

OK try this...

1st, delete the rule you have there, then create a new rule - Use Formula
"applies to" entire range
=C3=MIN($C3:$F3)

That is working perfectly fine.
Thanks a lot FDibbins.
Attached is the working file as a reference to others who are facing the same problem.

[FDibbins]

Happy to help and thanks for sharing the finished product