Menu
  1. Accueil
  2. Tech Forum
  3. Office Software
  4. Excel
Previous Topic Next Topic

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

Report
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
 -
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
 -
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

Answer 1 / 2
Posts
1924
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
June 10, 2021
 143
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
Answer 2 / 2
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
OK - thanks, works fine
Ask a question

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!