Active cell has Conditional Formatting?

    Hi,
    How can i test in VBA if the active cell has conditional formatting?


    Apparently

    Code
    ActiveCell.SpecialCells(xlCellTypeAllFormatConditions).Select

    will hightlight all cells that have Conditional Formatting, but i cant figure on how to test the extive cell only.


    Thank you,
    Stefan

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login