Multiple Cell Conditional Formatting

[Hydro Man]

I’m using Excel 2003.
I would like to FILL cells A1 to AB1 with Red IF cell C1=n/a.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o> </o>
<o>How do I do this?</o>

Thanks in advance for help,
<o> </o>
Hydro Man

 

[Jonmo1]

Highlight A1:AB1
Click Format - Conditional Formatting
Select Formula Is
Enter the formula
=$C1="n/a"
Click Format - choose RED fill color
Click OK
Click OK

Hope that helps.

 

[Hydro Man]

Jonmo1,

Thank you for your help, I'm actually using 2007 at work. Sorry for the confution. I tried it but I didn't succeed.

Any suggestions?

 

[Joe4]

Is it because it does not have the text "n/a" nard-coded into the cell, but rather is returning the "#N/A" error as the result of a formula error?

If the formula error, then try this formula instead:
=ISNA($C1)

 

[Hydro Man]

Thank you jonmo1 and Joe4.

I appreciate your help very much,

Hydro Man