Insert word in cell based on value in another cell?

Solved/Closed
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - May 1, 2014 at 01:32 PM
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - May 1, 2014 at 02:06 PM
CONDITIONAL FORMATTING for cell A2:

if value in cell C3 is > than 500, then insert word "alert" in cell A2

what would the formula look like?
I know this is easy for some but not for me!

Thanks for any tips...

2 replies

Mazzaropi Posts 1980 Registration date Monday August 16, 2010 Status Contributor Last seen December 22, 2022 146
May 1, 2014 at 01:55 PM
doublewitt, Good afternoon.

"...CONDITIONAL FORMATTING for cell A2:..."
As the name says, Conditional Formatting only changes the FORMAT of a cell, not the content.
It works the aesthetic aspect of the cell.

For the formula:
A2 --> =IF(C3>500,"alert","")

Is this what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014
May 1, 2014 at 02:06 PM
OK - thanks, works fine
0