conditional formatting using formula to determine which cell to format

[curiousgirl05]

Hi I know this is easy for some engineers here, but just wondering if how I can make "MP1" at the first column be highlighted to yellow if MP1 data is equal to N/A, as shown in the image.

 

[allgoodnamestaken]

https://www.ablebits.com/office-addins-blog/2014/06/10/excel-conditional-formatting-formulas/

Basically you use conditional formatting with a formula that checks a true/false condition.

with yours i'd use the ISNA(cell) command for the true/false portion.

 

[Agent666]

You should use iserror() rather than isna() as isna() wasn't implemented in earlier versions of excel I think. Basically does the same thing, but will be more compatible with different versions of excel.

 

[curiousgirl05]

Allgoodnamestaken and Agent66, thanks for the input... I used ISERROR function and it worked! thanks!

 

[allgoodnamestaken]

I avoid using ISERROR because it encompasses too many types of errors. It obfuscates errors and mistakes by not being specific enough. Personally I have no interest in supporting my own spreadsheets on versions of excel earlier than what I use at work (Excel 2010), and if they don't work on those earlier versions I'm ok with that.