Conditional Formatting Question

[Kalmaklysm]

I have a cell (K1) that I would like to highlight a specific color, if there is match to "#N/A" in ANY cell in all of column "Y". Is there a way to do this?

I am using this to flag an error. Should a user override any cell that is not protected, and it breaks the formula in cell Y, cell Y will populate with #N/A. I want #N/A to trigger a protected cell (K1) to highlight a color, to indicate that there is an error somewhere on the sheet and it should be investigated.

I hope I made this clear, thanks!

 

[Asbestos_Jen]

You should be able to use the formula option in conditional format with:

=ISNA(K1)

 

[SanjayGMusafir]

Use this formula to CF K1 and revert -

=COUNTIF(Y:Y,"#N/A")

 

[Asbestos_Jen]

I didn't read the question very well. Sorry!

 

[Kalmaklysm]

Use this formula to CF K1 and revert -

=COUNTIF(Y:Y,"#N/A")

Thank you so much. I can't believe I couldn't figure this out. So simple. For some reason I think I was just omitting the "," after Y:Y when I was trying to do it myself. Thank you again!

 

[SanjayGMusafir]

Thank you so much. I can't believe I couldn't figure this out. So simple. For some reason I think I was just omitting the "," after Y:Y when I was trying to do it myself. Thank you again!

Glad to help you and thanks for the feedback.

It can happen to anybody at times.