Forum Discussion
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.
- 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.
- This is awesome and now I see the formula I understand it.
select 200 columns then do insert columns
