SOLVED

Copying Conditional Formatting - Not Really Even Sure How to Ask

%3CLINGO-SUB%20id%3D%22lingo-sub-3025192%22%20slang%3D%22en-US%22%3ECopying%20Conditional%20Formatting%20-%20Not%20Really%20Even%20Sure%20How%20to%20Ask%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3025192%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20apply%20the%20conditional%20formatting%20in%20cell%20C2%20to%20all%20the%20cells%20in%20column%20C.%26nbsp%3B%20What%20I'd%20like%2C%20is%20for%20every%20value%20in%20column%20C%2C%20determine%20if%20it%20is%20greater%20than%20the%20value%20in%20the%20same%20row%20but%20in%20column%20B.%26nbsp%3B%20There%20has%20got%20to%20be%20a%20fast%20way%20to%20do%20that%20without%20having%20a%20separate%20conditional%20formatting%20rule%20for%20every%20row%20in%20column%20C%20-%20but%20I%20just%20have%20not%20been%20able%20to%20figure%20it%20out.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3025192%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3026030%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20Conditional%20Formatting%20-%20Not%20Really%20Even%20Sure%20How%20to%20Ask%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3026030%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1235727%22%20target%3D%22_blank%22%3E%40Diggy18%3C%2FA%3E%26nbsp%3BChanged%20the%20CF%20to%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-12-02%20at%2007.52.32.png%22%20style%3D%22width%3A%20560px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F331138iC7FA7BB6C602429C%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-12-02%20at%2007.52.32.png%22%20alt%3D%22Screenshot%202021-12-02%20at%2007.52.32.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThat%20seems%20to%20do%20what%20you%20want.%20See%20attached.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm trying to apply the conditional formatting in cell C2 to all the cells in column C.  What I'd like, is for every value in column C, determine if it is greater than the value in the same row but in column B.  There has got to be a fast way to do that without having a separate conditional formatting rule for every row in column C - but I just have not been able to figure it out.

 

Thanks!

2 Replies
best response confirmed by Diggy18 (New Contributor)
Solution

@Diggy18 Changed the CF to this:

Screenshot 2021-12-02 at 07.52.32.png

That seems to do what you want. See attached.

 

@Riny_van_EekelenAwesome thanks!  Seems like that should have been straightforward but I could not get it.