Cell A1 is red based on a conditional format I have set up. I want to do the
following: If cell A1 is red because of conditional format, then make cell
A2 red.