Forum Discussion
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
=$B$2="Sample Received"
=$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
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.
5 Replies
- 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
=$B$3="Sample Received"
=$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 lineI 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.
