Forum Discussion
Cells with a green corner in an Excel table: how to detect this error with a formula?
Hello, I am looking for a solution to detect the presence of cells with a green corner in a wide table, without having to visually inspect it cell after cell. My preference would go for a formula. As I could not find it, I assume it does not exist yet and a macro-based solution would then suit (better than nothing).
Thank you very much in advance to anybody who could help me in this research.
Best regards,
Frédéric
Detecting cells with a green corner (indicating an error in Excel) using a formula is not directly possible because Excel does not provide a built-in function to check for such visual formatting, so far I know. However, you can achieve this with VBA (macros) to search for cells with a green corner and perform actions based on that.
You find a VBA macro in the attached file maybe that can help you to detect cells with a green corner in a specified sheet and show them.
You will find the code in the inserted file.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
4 Replies
Then green idicator is not about an actual error but a warning for a potenional error.
Have a look at this discussion. Maybe there is something you can use.
Detlef_Lewin Hello Detlef, thank you for your answer. In my application, I consider it as an error, because the main table is fed with drop down menus which content (list) is pre-defined in auxiliary tables. If I change the auxiliary tables' content, by chance the cells in the main table are marked with a green corner, bringing the attention to main table content which is not valid any more. That's why I consider it as an error in my specific application.
Detecting cells with a green corner (indicating an error in Excel) using a formula is not directly possible because Excel does not provide a built-in function to check for such visual formatting, so far I know. However, you can achieve this with VBA (macros) to search for cells with a green corner and perform actions based on that.
You find a VBA macro in the attached file maybe that can help you to detect cells with a green corner in a specified sheet and show them.
You will find the code in the inserted file.
My answers are voluntary and without guarantee!
Hope this will help you.
Was the answer useful? Mark as best response and like it!
This will help all forum participants.
NikolinoDE Thank you Nikolino.
