I would like to configure a conditional format on a cell to highlight the cell if its content raises a data validity error.
In my case, the data validity allows the user to bypass data validation if she or he wants it (and it’s something I want to keep).
What I want is to apply a style like “Error” when the cell is not valid and “Text” if it is valid.
How can I achieve this?
Thanks by advance