Forum Discussion

jg228508's avatar
jg228508
Copper Contributor
Mar 17, 2022

Conditional Formatting - Not working on certain cells

I have conditional formatting set up to highlight cell "X" if said cell value is greater than or less than a certain value "Y". Value Y is determine by a calculation. 

 

The formatting is working fine when cell X is the original equation that i had in the cell prior to applying the conditional formatting. If i change the equation, or just type a number in place of my original equation, then the formatting doesn't show up...

 

EXAMPLE

 

Cell X = P5-L5 (=0.27)

My formatting highlights values above 0.25 and below -0.25

 

If I replace cell X with the number 2, or = 5-3, the cell does not highlight. 

 

Any thoughts?

1 Reply

  • jg228508 

    It'd help if you could attach a sample workbook, or make it available through OneDrive, Google Drive, Dropbox or similar.

Resources