Colour Stirpes

Hello Fergus,

Hope you enjoyed your Microsoft Excel course with BEST Training.

Thank you for your question regarding colouring lines.

Probably the best place to look first would be CONDITIONAL FORMATTING. It allows you to set a condition that when met, the cell will automatically colour itself.

e.g.
If the value in the cell is >100, then make the background colour Red.

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,

Richard