I want to change the colour of the font depending on the value that is entered into that cell.

For example if the value is greater than 99 I want the font to be Red. I the value is less than 99 I want the font to be blue.

Can anyone help me on this?

Many thanks,

Howdy.

What happens if it is exactly 99?

I assume you have a range of cells that you want to have this happen to. Say the range is B4:J10, select that range, then go to Format > Conditional Format, and on the left, in the dropdown box, make sure it is "Cell value is", then in the middle dropdown choose "is greater than", then in the right box, type 99. Click the Format button on the middle right and set your font color. Click OK.

While still in the Confitional Formatting dialog box, click on the Add button at the bottom, and choose same as above, only in the middle box, select "is less than", then click Format button and set your font color. Click OK. Click OK.

Perfect - nice and clear and easy to understand -

Thanks again

Great. And it is appreciated that you came back with the results, too.