calculating and coloring

D

djohns158

I have a formula to calculate the percentage of profit on a line
item: =(F2/G2)
Now I want to make it so that if the percentage falls below 133%, the
cell displays the number in red. I know this is probably easy for the
experts, but I can't seem to figure it out. Could somebody take pity
on my poor, uneducated self and help me with this?
 
M

Mike H

Select the cell then
Format|conditional format
Cell value is
Less than
133%
Pick a colour

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top