Ask a question Report

Insert word in cell based on value in another cell? [Solved/Closed]

doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen - May 1, 2014 at 01:32 PM - Latest reply: doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen

- May 1, 2014 at 02:06 PM

Excel Ask a question Report

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

Report Respond to Mazzaropi

Mazzaropi 1834 Posts Monday August 16, 2010Registration dateContributorStatus May 30, 2018 Last seen - May 1, 2014 at 01:55 PM

Thank you

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

Report Respond to doublewitt

doublewitt 14 Posts Sunday April 27, 2014Registration date September 29, 2014 Last seen - May 1, 2014 at 02:06 PM

Thank you

OK - thanks, works fine

Ask a question

Insert word in cell based on value in another cell? [Solved/Closed]

Your reply