Conditional Format Question

[Busymanjohn]

Hi guys, I have a small query. Is it possible to use Conditional Format to highlight a cell if the sum of that cell minus another cell is greater than 100 .... so, if the sum of C5-K5 is greater than 100 highlight RED. I've tried various things and none seem to work.

 

[xld]

Just use CF with a formula of


=C5-K5>100


and format as required

 

[Busymanjohn]

Hi xld ,,,, thanks for the reply ,,, but after playing around some more I discovered that I had the formula back to front ( Doh! ) ... should be K5-C5>100 for it to work, but thanks for the reply, your reply is correct ..... see what happens when you take a couple of weeks off, brain becomes mush ,, lol