Conditional Formatting - Adding Text

  • Thread starter Thread starter MSWEENEY
  • Start date Start date
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
 
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)
 
Back
Top