VBA to return the details of condtional formatting
Posted on 2014-09-22
I have two questions,
is it possible to have a vba code that lists all of the condtional formatting range and its condtional formula in a workbook?
secondly, how to set condtional formatting using vba.
for example in SELECTION OF range A1:A20 i want to set the formula =COUNTIFS($B$1:$B$20,$A1) in the condtional formatting to highlight it in yellow if the condtion is met.
appreciate your help.