Previous Topic Next Topic

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?

1 response

Answer 1 / 1
MaxStart Posts 339 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")
1
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
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses