Conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-899394%22%20slang%3D%22en-US%22%3EConditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-899394%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20please%20tell%20me%20where%20I%20am%20going%20wrong%20with%20my%20conditional%20formatting%3F%20I%20am%20trying%20to%20set%20it%20up%20so%20that%26nbsp%3Ba%20cell%20will%20turn%20red%20if%20the%20number%20input%20is%20less%20that%20the%20corresponding%20number%20in%20the%20first%20column%20of%20that%20row.%20So%2C%20if%20the%20number%20in%20A2%20is%2097%20and%2096%20is%20put%20in%20B2%2C%20it%20will%20turn%20red.%20However%2C%20if%20103%20is%20in%20C2%2C%20it%20won't%20turn%20red.%20I%20want%20each%20row%20to%20work%20independently%20and%20look%20at%20the%20first%20cell%20in%20the%20corresponding%20row%20only.%20Thanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-899394%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConditional%20Formatting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899488%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-899488%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392988%22%20target%3D%22_blank%22%3E%40oconnells%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EConditional%20formatting%20in%20your%20file%20was%20linked%20(Freeze)%20to%20Column%20A%20only.%20I%20have%20modified%20it.%20Hopefully%20it%20will%20work%20as%20desired.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20see%20the%20attached%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899525%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-899525%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%20it%20still%20doesnt%20work.%20Any%20cells%20in%20columns%20B%2CC%20or%20D%20that%20contain%20a%20figure%20lower%20than%20the%20corresponding%20figure%20in%20column%20A%20should%20be%20red.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJonathan%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899575%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-899575%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Jonathan%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20apology%2C%20small%20issue%20in%20the%20formula%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20check%20it%20now.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899620%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-899620%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20-%20that%20works!%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F239215%22%20target%3D%22_blank%22%3E%40tauqeeracma%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-899678%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-899678%22%20slang%3D%22en-US%22%3E%3CP%3EYou%26nbsp%3Bare%20welcome%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F392988%22%20target%3D%22_blank%22%3E%40oconnells%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Can someone please tell me where I am going wrong with my conditional formatting? I am trying to set it up so that a cell will turn red if the number input is less that the corresponding number in the first column of that row. So, if the number in A2 is 97 and 96 is put in B2, it will turn red. However, if 103 is in C2, it won't turn red. I want each row to work independently and look at the first cell in the corresponding row only. Thanks

5 Replies
Highlighted

Hi @oconnells 

 

Conditional formatting in your file was linked (Freeze) to Column A only. I have modified it. Hopefully it will work as desired.

 

Please see the attached file.

 

Thanks

Tauqeer

Highlighted

@tauqeeracma 

 

Hi, it still doesnt work. Any cells in columns B,C or D that contain a figure lower than the corresponding figure in column A should be red.

 

Jonathan

Highlighted

Hi Jonathan

 

My apology, small issue in the formula

 

please check it now.

 

Thanks

Tauqeer

 

Highlighted

Thanks - that works! @tauqeeracma 

Highlighted

You are welcome @oconnells