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
How to clear formatting in excel - Guide
Phone formatting software for pc - Download - File management
Formatting usb mac - Guide
Enable support for other file formats, such as pdf and xps - Download - Other
How to change date format in excel from text to dd/mm/yyyy - Guide

1 response

Answer 1 / 1

MaxStart Posts 338 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

Similar discussions

Highlight cell if another cell contains specific text

How to use conditional format based on text?

What shall i do after formatting my laptop?

Conditional Formatting: 3 range of numbers

Similar discussions

Subscribe To Our Newsletter!