Conditional formatting.

Spreadsheetdimwit wrote:

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??