Conditional Formatting

Hello Karen,

Thank you for your question regarding Conditional Formatting.

The first thing that comes to mind is that your test formula may have produced hidden results which will be exposed if you increase the decimal places. Remember a true zero cannot have any decimals.

If this is the case then simply add the ROUND function to your formula as follows:

=ROUND('your formula',0)

I have attached a file showing a simple example of how this works.

Should this not be the case I suggest you send me a sample file to my email: rl@stl-training.co.uk

I do hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer