Thank you for reply. I did not express my question well. Let me explain it with an example.

For cell A1 I put condition formatting of if A1=1, then shade the cell in red. I want to know if the cell is turned red or not. Thanks.