Hi Everyone,

I'm trying to apply some conditional formating on a formulas used in a form,

I want the text colour to go to white when the formulas = "#N/A"

but excel seams to see the formulas instead of the "#N/A"

how would I go about making the "#N/A" white, i just don't want the users of the form to think it's and Error.