Conditional Formatting as a text

Closed

clauxman Posts 1 Registration date Saturday April 4, 2015 Status Member Last seen April 4, 2015 - Apr 4, 2015 at 07:37 PM
Aglo - Sep 15, 2015 at 02:58 PM

I'm trying to create a conditional formatting to come up as a text. For example I want an if then statement...
if the cell = 7, I want a text to come up as "go to room..."

any help?

Conditional Formatting as a text
Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
Conditional formatting if another cell contains any text ✓ - Excel Forum
Conditional format based on another cell containing text - Excel Forum
Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
Highlight cell if another cell contains specific text - Excel Forum

1 reply

Answer 1 / 1

MaxStart Posts 340 Registration date Tuesday March 3, 2015 Status Moderator Last seen July 3, 2015 69
Apr 4, 2015 at 07:44 PM

you don't need conditional formatting for this just a simple formula

=IF(A1=7,"go to room","another value if not")

Aglo
Sep 15, 2015 at 02:58 PM

Hi, that conditional format help me as well, however, what if its not just seven, (in the example above), if it was 7,9 and 10 per say..

Thanks for your help

Subscribe To Our Newsletter!