It is not easy to test for conditionally formatted cells, far better to test for the same criteria that sets it red. What is the condition?