Conditional Formatting as a text

Closed

clauxman Posts 1 Registration date Saturday 4 April 2015 Status Member Last seen 4 April 2015 - 4 Apr 2015 à 19:37
Aglo - 15 Sep 2015 à 14:58

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 clear formatting - Guide
Excel conditional formatting based on date - Guide
Risk formatting excel - Excel Forum
Conditional formatting if cell contains text - Excel Forum
Highlight cell if another cell contains any text ✓ - Excel Forum

1 response

Réponse 1 / 1

MaxStart Posts 338 Registration date Tuesday 3 March 2015 Status Contributor Last seen 3 July 2015 69
4 Apr 2015 à 19:44

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

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

Aglo
15 Sep 2015 à 14:58

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

Similar discussions

Highlight cell if another cell contains specific text

How to use conditional format based on text?

Conditional formatting based text in another cell

Conditional Format Cells Based on Another Cell and Own Cell

Conditional Formatting - highlight overdue dates

Similar discussions

Subscribe To Our Newsletter!