SOLVED

Conditional formatting with multiple rows.

%3CLINGO-SUB%20id%3D%22lingo-sub-1561476%22%20slang%3D%22en-US%22%3EConditional%20formatting%20with%20multiple%20rows.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561476%22%20slang%3D%22en-US%22%3EGood%20afternoon!%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20trying%20to%20get%20conditional%20formatting%20to%20work%20across%20rows.%20There%20are%204%20cells%20in%20each%20row%20that%20the%20formatting%20will%20compare%20against%20two%20times%20listed%20at%20the%20end%20of%20each%20row.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20it%20possible%20to%20copy%20the%20formatting%20so%20that%20each%20row%20will%20compare%20against%20the%20times%20at%20the%20end%20of%20that%20row%20instead%20of%20the%20original%20times%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20have%20attached%20a%20photo%20to%20show%20the%20formatting.%20Each%20cell%20i2%2C%20n2%2C%20r2%20should%20compare%20u2%20%26amp%3B%20v2%20and%20highlight%20if%20not%20between.%20I%20need%20this%20to%20copy%20to%20the%20next%20row%20as%20there%20are%20over%20100%20rows.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20appreciate%20any%20help%20anyone%20can%20give.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1561476%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561573%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20with%20multiple%20rows.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561573%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F740437%22%20target%3D%22_blank%22%3E%40Flambert86%3C%2FA%3E%26nbsp%3B%2C%20you%20can%20change%20the%20absolute%20reference%20(%24U%242%2C%20%24V%242)%20to%20relative%20reference%20(%24U2%2C%20%24V2)%20and%20apply%20the%20CF%20to%20the%20cells%20below.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1561689%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20with%20multiple%20rows.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1561689%22%20slang%3D%22en-US%22%3EFantastic.%20Thanks%20again!%3C%2FLINGO-BODY%3E
Occasional Contributor
Good afternoon!

I am trying to get conditional formatting to work across rows. There are 4 cells in each row that the formatting will compare against two times listed at the end of each row.

Is it possible to copy the formatting so that each row will compare against the times at the end of that row instead of the original times?

I have attached a photo to show the formatting. Each cell i2, n2, r2 should compare u2 & v2 and highlight if not between. I need this to copy to the next row as there are over 100 rows.

I appreciate any help anyone can give.
2 Replies
best response confirmed by Flambert86 (Occasional Contributor)
Solution

@Flambert86 , you can change the absolute reference ($U$2, $V$2) to relative reference ($U2, $V2) and apply the CF to the cells below. 

Fantastic. Thanks again!