Conditional Formatting to Highlight a Numeric and Percentage Change

[Chris Waller]

Hi All,

I am trying to create a condittional format to highlight cells that meet the following criterir. If the cell is greater then or equal to 50 (any number I choose) and greater than or equal to 10%.

I have started with =if(and(a1-b1>=50, I just don't know how to finish the formula off. I suspect if is something on the lines of >=0.01), but I am not sure. Any help would be appreciated. I am still trying various options to see what will work.

 

[mart37]

I think you needed no IF().
The result of the formula must be TRUE or FALSE to use CF.
=and(a1-b1>=50,a1>=10%*B1)

 

[Chris Waller]

I think you needed no IF().
The result of the formula must be TRUE or FALSE to use CF.
=and(a1-b1>=50,a1>=10%*B1)

mart37,

Thanks for your response and it did partially work. What I would also like is to check for negative figures as well.
TIA

 

[Sandie1712]

Chris

Could you pl share your data

Thanks!!

 

[mart37]

=and(a1-b1>=50,a1>=10%*b1,a1>=0)