Home

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
oconnells
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

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

@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

Hi Jonathan

 

My apology, small issue in the formula

 

please check it now.

 

Thanks

Tauqeer

 

Thanks - that works! @tauqeeracma 

You are welcome @oconnells 

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies