SOLVED

Conditional Formatting in Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-2424650%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2424650%22%20slang%3D%22en-US%22%3EI%20am%20trying%20to%20compare%20cells%20in%20different%20columns%20using%20conditional%20formatting.%20I%20was%20hoping%20someone%20could%20help%20me%20with%20creating%20my%20own%20formula.%3CBR%20%2F%3EFor%20example%3A%20F3%20turns%20red%20if%20it%E2%80%99s%20value%20(numbers)%20is%20less%20than%20E3%20and%20F3%20turns%20yellow%20if%20it%20is%20more%20than%20E3.%20If%20E3%20and%20F3%20values%20are%20equal%2C%20I%20want%20it%20to%20have%20no%20color%20indication.%3CBR%20%2F%3EI%20understand%20how%20to%20create%20the%20condition%20but%20I%20do%20not%20know%20how%20the%20formula%20should%20be%20written.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20advise!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2424650%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2424826%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2424826%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1073351%22%20target%3D%22_blank%22%3E%40senoi%3C%2FA%3E%26nbsp%3BPerhaps%20easiest%20to%20demonstrate%20in%20a%20working%20example.%20See%20attached.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-06-08%20at%2006.06.45.png%22%20style%3D%22width%3A%20168px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F287085iD604F92CA6D4CBDD%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-06-08%20at%2006.06.45.png%22%20alt%3D%22Screenshot%202021-06-08%20at%2006.06.45.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-06-08%20at%2006.06.26.png%22%20style%3D%22width%3A%20178px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F287086iFB888B0397056131%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-06-08%20at%2006.06.26.png%22%20alt%3D%22Screenshot%202021-06-08%20at%2006.06.26.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2429225%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2429225%22%20slang%3D%22en-US%22%3EIs%20possible%20for%20you%20to%20show%20a%20screenshot%20of%20the%20formula%20you%20used%20to%20create%20your%20example%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2429257%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20in%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2429257%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1073351%22%20target%3D%22_blank%22%3E%40senoi%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22StoneKiwi_0-1623205754778.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F287335iBB899C63628355DB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22StoneKiwi_0-1623205754778.png%22%20alt%3D%22StoneKiwi_0-1623205754778.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor
I am trying to compare cells in different columns using conditional formatting. I was hoping someone could help me with creating my own formula.
For example: F3 turns red if it’s value (numbers) is less than E3 and F3 turns yellow if it is more than E3. If E3 and F3 values are equal, I want it to have no color indication.
I understand how to create the condition but I do not know how the formula should be written.

Please advise!
8 Replies

@senoi Perhaps easiest to demonstrate in a working example. See attached.

Screenshot 2021-06-08 at 06.06.45.png

Screenshot 2021-06-08 at 06.06.26.png

 

Is possible for you to show a screenshot of the formula you used to create your example?
best response confirmed by senoi (Occasional Contributor)
Solution

@senoi 

StoneKiwi_0-1623205754778.png

 

Thank you so much, I knew it was something simple
It didn’t work.

@senoi Better to open the file that I attached. It contains two ways of achieving the result you asked for. But if you insist on a screenshot, here it is.

Screenshot 2021-06-09 at 05.54.00.png

I tried opening the file, it came up only as like a screenshot. I will try again. I’m still learning and I’m new to the community. Thank you for your help.

@senoi 

 

When you click a file on here it opens a preview of the file that looks like an image.

To download the file click the highlighted 'download' button shown below.

 

StoneKiwi_0-1623269610952.png