<div>
<div class="content wysiwyg-content">
I have two questions,<br />
<br />
is it possible to have a vba code that lists all of the condtional formatting range and its condtional formula in a workbook?<br />
<br />
secondly, how to set condtional formatting using vba.<br />
<br />
for example in SELECTION OF range A1:A20 &nbsp;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.<br />
<br />
appreciate your help.
</div>
</div>


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.

VBA to return the details of condtional formatting

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.