-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Green Flags
- Thread starter len.betts
- Start date
MARK858
MrExcel MVP
- Joined
- Nov 12, 2010
- Messages
- 16,192
- Office Version
- 365
- Platform
- Windows
- Mobile
File - Options - Formulas and uncheck the box indicated, for individual rules uncheck the boxes in the section below it (this is assuming you have a later version of Excel as you haven't stated what version you have)
If you want to just do it on an individual range select the cells from the top left to the bottom right cell, right click, click the yellow triangle dropdown and click Ignore Error
If you want to just do it on an individual range select the cells from the top left to the bottom right cell, right click, click the yellow triangle dropdown and click Ignore Error
Last edited:
Upvote
0
