Hello,

I am fairly new to working with Excel, i want to know if it possible to have cells show in colour. I'll explain in a little more detail.

I want the cell to; Show in red for cells that are lower then a profit value, and green for cells that are above a profit value

Not really sure how to explain what i want to do, basically the spread sheet is so i can easily see where competitors are beating my prices and when they are not.

Is this even possible?

Andrew