Hello,

Im sure this has been answered before, but I cannot find an exact answer using the search function. Any help would be greatly appreciated.

I have 2 columns

A B
2.00 12

Column a is a value which is derived from a formula
Column b is a value which is also derived from a formula

I need to colour the font blue in A when b=12,
I also need to colour the font red when B=14.

There are only 2 possibilities that will occur in Column B, 12 & 14.

How can I do this?

Regards,

James.