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:
- Insert word in cell based on value in another cell?
- If cell contains (multiple text criteria) then return (corresponding text criteria) ✓ - Excel Forum
- Based on the values in cells b77 b81 ✓ - Excel Forum
- If cell contains specific text then return value in another cell vba ✓ - Excel Forum
- If cell contains text then return value in another cell ✓ - Excel Forum
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
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
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