SOLVED

New Contributor

# Copy Conditional formatting for each row

Hi, I have set up a drop down menu with several status and each status gives a different color for the row.

Colum B, I have a status selection

The rows I want to change colour for each status

=\$A\$2:\$F\$2

=\$B\$2="Sample Sent"

=\$A\$2:\$D\$2

=\$B\$2="Result sent"

=\$A\$2:\$I\$2

I want the same for Row 3 but not sure how to duplicat it

5 Replies

=\$A\$2:\$F\$3

# Re: Copy Conditional formatting for each row

Hi thanks for reading and your reply. This take the colour to the next level, I have probably not made my instructions clear.

I am looking to make the next line work by using

=\$A\$3:\$F\$3

=\$B\$3="Sample Sent"

=\$A\$3:\$D\$3

=\$B\$3="Result sent"

=\$A\$3:\$I\$3

The problem I need to fo to row 200 and did not want a load to wright out fr each line

# Re: Copy Conditional formatting for each row

select 200 columns then do insert columns

best response confirmed by Baggy1977 (New Contributor)
Solution

# Re: Copy Conditional formatting for each row

I understand that you want to

- highlight range A2:F2 if "sample received" is in cell B2

- highlight range A3:F3 if "sample received" is in cell B3

and so on.

In the attached file i inserted dropdowns in range B2:B201 with the values from range J1:J3. This might be what you want to do. The formulas i suggested in my last post work accordingly for range B2:B3. Unfortunately from your initial question i didn't understand that there are actually 200 rows in your file.

# Re: Copy Conditional formatting for each row

This is awesome and now I see the formula I understand it.