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
- We couldn't find an account matching the login info you entered, but found an account that closely matches based on your login history ✓ - Facebook Forum
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
- Conversion of values already present in cells ✓ - 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
