Is it possible to test a range of conditionally formatted cells such that:
If any cell in the range is either conditionally formatted yellow or green then End macro
Otherwise, continue executing macro.
ps:the conditional format is testing the number of spaces in each of several cells in a range. The cells must each have exactly 1 space. If the cell has no spaces, it conditionally formats to green. If it has more than 1 space, it conditionally formats to yellow. I want the macro to check the cell colors to make sure all cells have exactly 1 space before continuing. If any cell in the range doesn't have exactly one space, I want the macro to end.
If any cell in the range is either conditionally formatted yellow or green then End macro
Otherwise, continue executing macro.
ps:the conditional format is testing the number of spaces in each of several cells in a range. The cells must each have exactly 1 space. If the cell has no spaces, it conditionally formats to green. If it has more than 1 space, it conditionally formats to yellow. I want the macro to check the cell colors to make sure all cells have exactly 1 space before continuing. If any cell in the range doesn't have exactly one space, I want the macro to end.