conditional formatting using formula to determine which cell to format
conditional formatting using formula to determine which cell to format
(OP)
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. 






RE: conditional formatting using formula to determine which cell to format
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.
RE: conditional formatting using formula to determine which cell to format
RE: conditional formatting using formula to determine which cell to format
RE: conditional formatting using formula to determine which cell to format