SOLVED

Copy Conditional formatting for each row

%3CLINGO-SUB%20id%3D%22lingo-sub-3119546%22%20slang%3D%22en-US%22%3ECopy%20Conditional%20formatting%20for%20each%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3119546%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20have%20set%20up%20a%20drop%20down%20menu%20with%20several%20status%20and%20each%20status%20gives%20a%20different%20color%20for%20the%20row.%26nbsp%3B%3C%2FP%3E%3CP%3EColum%20B%2C%20I%20have%20a%20status%20selection%3C%2FP%3E%3CP%3EThe%20rows%20I%20want%20to%20change%20colour%20for%20each%20status%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%24B%242%3D%22Sample%20Received%22%3C%2FP%3E%3CP%3E%3D%24A%242%3A%24F%242%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%24B%242%3D%22Sample%20Sent%22%3C%2FP%3E%3CP%3E%3D%24A%242%3A%24D%242%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%24B%242%3D%22Result%20sent%22%3C%2FP%3E%3CP%3E%3D%24A%242%3A%24I%242%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20the%20same%20for%20Row%203%20but%20not%20sure%20how%20to%20duplicat%20it%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3119546%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3119652%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20Conditional%20formatting%20for%20each%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3119652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1297684%22%20target%3D%22_blank%22%3E%40Baggy1977%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DAND(ROW()%3DROW(%24B2)%2C%24B2%3D%22Sample%20Received%22)%3C%2FP%3E%3CP%3E%3D%24A%242%3A%24F%243%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20works%20in%20my%20spreadsheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3119655%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20Conditional%20formatting%20for%20each%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3119655%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1297684%22%20target%3D%22_blank%22%3E%40Baggy1977%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3D%24B2%3D%22Sample%20Received%22%3C%2FP%3E%3CP%3E%3D%24A%242%3A%24F%243%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20works%20in%20my%20spreadsheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3120137%22%20slang%3D%22en-US%22%3ERe%3A%20Copy%20Conditional%20formatting%20for%20each%20row%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3120137%22%20slang%3D%22en-US%22%3EHi%20thanks%20for%20reading%20and%20your%20reply.%20This%20take%20the%20colour%20to%20the%20next%20level%2C%20I%20have%20probably%20not%20made%20my%20instructions%20clear.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20looking%20to%20make%20the%20next%20line%20work%20by%20using%3CBR%20%2F%3E%3CBR%20%2F%3E%3D%24B%243%3D%22Sample%20Received%22%3CBR%20%2F%3E%3CBR%20%2F%3E%3D%24A%243%3A%24F%243%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3D%24B%243%3D%22Sample%20Sent%22%3CBR%20%2F%3E%3CBR%20%2F%3E%3D%24A%243%3A%24D%243%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3D%24B%243%3D%22Result%20sent%22%3CBR%20%2F%3E%3CBR%20%2F%3E%3D%24A%243%3A%24I%243%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20problem%20I%20need%20to%20fo%20to%20row%20200%20and%20did%20not%20want%20a%20load%20to%20wright%20out%20fr%20each%20line%3C%2FLINGO-BODY%3E
New Contributor

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

 

 

5 Replies

@Baggy1977 

=$B2="Sample Received"

=$A$2:$F$3

 

This works in my spreadsheet.

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 line

select 200 columns then do insert columns

best response confirmed by Baggy1977 (New Contributor)
Solution

@Baggy1977 

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.

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