Text in Conditional formatting

[Dave White]

Hi,

I want to use conditional formatting to highlight a cell where i put in a
specific word.

eg: if I type in the word 'required. the cell changes to red etc... when the
cell is blank I dont want the cell to do anything.. only when I type in a
'word' and that word has to be letter perfect.. ie... req and it wont change
the cell colour... it will only change when i type in the word exactly ie
'required'

thanks

 

[T. Valko]

When you say exactly, do you mean that literally?

For example:

required
Required
REQUIRED

None of those *exactly* match. Is that what you want?

 

[Dave White]

Hi... yes... i want the cell to change colour when i type a word in it... ie:

yellow.... type that in and the cell will highlight... type in yello and
nothing happens.... same with if I type in nothing... i only want the cell to
change when I type in a word (like yellow) !

 

[T. Valko]

Select the cell you want to highlight.
Let's assume it's cell A1
Goto the menu Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A1="required"
Click the Format button
Select the Patterns tab
Select a fill color
OK out

 

[Dave White]

YUP !!!! perfect !!!

many many thanks... didnt realise it was THAT simple !

 

[T. Valko]

You're welcome. Thanks for the feedback!