I think you will need to step through the rows, carry out the test - whatever
you used for the conditional formatting - and then color the rows.
I do not think it is possible just to look at the cell and see what colour the
conditional formatting makes it.