Hi

Can someone help with this - having a bit of trouble.

I've got two columns - last years bonus target % and this years%. Last year some people didn't have one so it just shows NO TARGET.

I want to put a conditional format on this years target so that it shows in red if it is different from last years (but ignoring anyone that has NO TARGET for last year because that will obviously be different.

e.g.
Last year This year
10% 15%
NO TARGET 25%

I want the 15% to be in red.

Probably really simple!
thanks!