Conditional formatting using multiple conditions

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!

Use conditional formatting in which you will put the formula:

=IF(AND(NOT(EXACT(B4;"NO TARGET"));B4=C4);0;1)

There might be a less complicated formula but this should work. Replace ";" with "," if needed.

Hi

thanks for that...it's still highlighting the cells where last year said NO TARGET though....any ideas? I want it to ignore those ones.

Thx

the EXACT function will check if the cell matches exactly the value. Do you have No Target in those cells by any chance?
If you don't have NO TARGET everywhere you can use

=AND(NOT(EXACT(UPPER(D8);"NO TARGET"));D8=E8)