Conditional Formatting

Hello Charlie,

Hope you enjoyed your Microsoft Excel Advanced course with Best STL.

Thank you for your question regarding conditional formatting.

All positive numbers are greater than zero and all negative numbers are less than zero. Select the data that requires conditional formatting and from the Conditional Formatting button use Highlight Cells Rules followed by Greater Than... Insert a Zero then choose your colour. Repeat the process, only this time use the Less Than option.

I 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