Conditional formatting - formula for blank or specific text

[weeksy]

Hi all

I'm struggling to add some conditional formatting to a worksheet. I'm trying to grey out cell V6 if cell U6 is either blank or contains N/A. I tried an OR formula (=OR(U6=N/A,ISBLANK(U6))) but it didn't grey out my cell with either N/A or blanks in the other cell, so I know I've gone wrong somewhere. I'm sure it is simple but all of my internet searches only gave me OR formulas using only text, or IS Blanks formulas only, but not combination of the two.

Any help gratefully appreciated!

Many thanks

Hilary

 

[Joe4]

Are the "N/A" values literal text values of "N/A", or is it the "#N/A" error?

If literal text, try:

=OR(U6="N/A",U6="")

If #N/A error, try:

=OR(ISNA(U6),U6="")

 

[weeksy]

Are the "N/A" values literal text values of "N/A", or is it the "#N/A" error?

If literal text, try:

=OR(U6="N/A",U6="")

If #N/A error, try:

=OR(ISNA(U6),U6="")

I knew there'd be an easy solution. Perfect thanks.

 

[Joe4]

You are welcome.
Glad I was able to help!