Conditional Formatting as a text

[Closed]
Report
Posts
1
Registration date
Saturday April 4, 2015
Status
Member
Last seen
April 4, 2015
-
 Aglo -
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 reply

Posts
341
Registration date
Tuesday March 3, 2015
Status
Moderator
Last seen
July 3, 2015
68
you don't need conditional formatting for this just a simple formula
=IF(A1=7,"go to room","another value if not")

1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2821 users have said thank you to us this month

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