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.
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.