Colour to a Cell

[KevinShawn]

Is there a way to establis a cell to be coloured if certain criteria are met.

For example if the varaince between the actual sales each month drops below the target sales can I colour the name of the individual that did not make the required target?

 

[VoG]

Hello and welcome to MrExcel.

Take a look at Conditional Formatting http://www.contextures.com/xlCondFormat01.html

 

[KevinShawn]

VoG.. Thank you.. that was fast.. exactly what I was looking for.