CONDITIONAL FORMATTING

%3CLINGO-SUB%20id%3D%22lingo-sub-2911468%22%20slang%3D%22en-US%22%3ECONDITIONAL%20FORMATTING%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2911468%22%20slang%3D%22en-US%22%3E%3CP%3EI%20can't%20do%20any%20basic%20conditional%20formatting%20at%20the%20cell%20level%20and%20range%20level%20any%20longer.%20The%20default%20choices%20(eg%20Greater%20Than)%20still%20work%20but%20only%20at%20the%20entire%20column%20level%20not%20a%20limited%20range%20level.%20I'm%20not%20new%20to%20it%20and%20I've%20done%20it%20many%20times%20before%20without%20issues.%20The%20last%20major%20change%20I%20did%20in%20'Options'%20is%20to%20change%20my%20cursor%20movement%20default%20to%20go%20to%20the%20right%20instead%20of%20down.%3C%2FP%3E%3CP%3EI%20'repaired'%20my%20Office%20365%20%26gt%3B%20didn't%20help%3C%2FP%3E%3CP%3EI%20rewrote%20the%20formula%20%26gt%3B%20didn't%20help%26nbsp%3B%3C%2FP%3E%3CP%3EI%20opened%20a%20new%20file%20and%20tried%20it%20there%20%26gt%3B%20same%20thing%3C%2FP%3E%3CP%3EAny%20suggestions%20would%20be%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2911468%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I can't do any basic conditional formatting at the cell level and range level any longer. The default choices (eg Greater Than) still work but only at the entire column level not a limited range level. I'm not new to it and I've done it many times before without issues. The last major change I did in 'Options' is to change my cursor movement default to go to the right instead of down.

I 'repaired' my Office 365 > didn't help

I rewrote the formula > didn't help 

I opened a new file and tried it there > same thing

Any suggestions would be appreciated.

1 Reply

@AHALAYAN 

Please include your Excel version, operating system, sample file (excluding sensitive data) to help others answer your question.

In addition, here is some information that might help.

Conditional formatting compatibility issues

 

Thank you for you all understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)