Conditional Formatting - Adding Text

M

MSWEENEY

I would like to be able to add conditional formating when a cell has a
value greater or less than "0".

For example: I have a number in cell P2. I want P3 to say the words
"Great Job" if the number in P2 is greater than 1%.

Everything that I try with conditional formatting limits me to the cell
that contains the value and does not allow me to manipulate the
adjacent cell.

Any help is greatly appreciated.

Thank you, Mark
 
B

Bob Phillips

How a bout a formula in P3

=IF(P2>1%,"Great Job","")

No CF involved.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top