Conditional Formatting as a text

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

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")

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