Forum Discussion
Cells with a green corner in an Excel table: how to detect this error with a formula?
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.
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.