how do I Change cell fill colour by placing letter in it

[Guest]

I have a spreadsheet which has some cells formatted to change their fill
colour to grey if the letter N is entered. I cannot figure out how to do
this so that I can use it on another spreadsheet, any ideas??

 

[garfield-n-odie [MVP]]

Conditional formatting.

 

[Dallman Ross]

I have a spreadsheet which has some cells formatted to change
their fill colour to grey if the letter N is entered. I cannot
figure out how to do this [. . .]

From the Menu: Format / Conditional Formatting...

Set Condition-1 to: Cell Value Equal To ="N"

Or maybe you'll want "Greater Than or Equal To" instead of "Equal To".
Then you can have the cell value *start* with "N" and have it gray,
such as the value "N/A" or "NA", etc.

 

[Don Guillett]

Select the cell with the condition>format>conditional formatting and you
will see