Kalmaklysm
New Member
- Joined
- Mar 20, 2024
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
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!
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!