Unfortunately, there's no access in VBA to the conditionally formatted
font.

In article ,
swatsp0p
wrote:

One solution would require VBA to analyse the font in each cell.