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
doublewitt Posts 14 Registration date Sunday April 27, 2014 Status Member Last seen September 29, 2014 - May 1, 2014 at 02:06 PM
Related:
- Based on the values in cells b77
- Excel macro to create new sheet based on value in cells - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
- Insert picture in Excel macro which takes the file name refrence - Excel Forum
- How would you change all cells containing the word pass to green - Excel Forum
- Based on the values in cells b77 b81 c77 ✓ - Excel Forum
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
May 1, 2014 at 01:55 PM
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
"...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
doublewitt
Posts
14
Registration date
Sunday April 27, 2014
Status
Member
Last seen
September 29, 2014
May 1, 2014 at 02:06 PM
May 1, 2014 at 02:06 PM
OK - thanks, works fine
