Conditional Formating

[Smulzeys]

Hello!

In advance, thanks for your time.

I was hoping you could help me as im not the best in excel.

What I am trying to do is use conditional formating to change the colour of a cell based on any word. Is there a command for any word? I am able to do it if there is just one word but the cell im talking about can be anything.

Please tell me if you need clarification.

Thanks again!

Tom


Marketing Director BIS

[Ace_XL]

Try this in CF

=ISTEXT(A1)

format--colour

[Fotis1991]

Hi Tom. Welcome to the forum.

Did you try using ISTEXT function?

Something like this in Conditional Formating rules?

=ISTEXT(a1)

[Smulzeys]

Thanks!

Thanks for your time.

Ill read you through my excel as it doesnt seem to be working. Lets call the cell in question cell A. I have two drop down lists that if one of the options on either is selected it will make cell A go orange. Once it is orange I want to make it go blank if someone types in it. While if noone types in it, it stays orange. Does this clarify? Or is what you two suggested right with me just doing it wrong.

Cheers,
Tom

[Fotis1991]

...I have two drop down lists that if one of the options on either is selected it will make cell A go orange.

2 drop down lists in the same cell?

Which is the condition to make the cell filled with Orange color?

Can you upload a sample workbook?

To attach a small sample workbook.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Smulzeys]

Here you go. If you go to the drop down menus and select other. The comment section will go orange. I want to know how, if you type in the comments section while its orange, to make it go white. Example.xlsx

did the attachment work?

[Fotis1991]

uSING istext.

[Smulzeys]

Oh is it because I am using a dutch version of excel?, which by the way do you know how to change the menu and stuff to english?

Thanks so much for your time.

[Smulzeys]

I have one more request if you have time. This one is like 100x more complicated.

[Fotis1991]

..Oh is it because I am using a dutch version of excel?,

I don't think so but i am not sure!

..which by the way do you know how to change the menu and stuff to english?

Sorry i don't know.

Thanks so much for your time.

You are welcome and thanks for the feed back.

As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thank you.