Detect cell conditional formatting state of specific condition

Is it possible to check the conditional state for a specific condition for a specific cell.
For example a cell has 1 or more conditions.
A condition will toggle to a condition if true or false etc.
The specifics is i use red (color 255) if a cell has not met a specific condition (of 1 or more conditions)
So if the cell is mandatory to be populated, and is blank, it will be red, if not it will be something else.

But i want to loop all visible cells with conditional formatting, and where the cell has a condition when true will show interior color = to 255 return the cell address.
To msg the user where data entry is still required etc.
Thanks

Originally Posted by solnajeff

Hi

You could try something like the following.

Please Login or Register  to view this content.

Regards

Jeff

I don't think you can get the interior.colorIndex from a conditional formatted cell, did you try it?

That wouldn't flag all invalid data, merely blank cells that have CF rules applied (the requirement to be populated might not even be one of the conditions). Chip Pearson has code here to detect active conditional formatting.