Convert Conditional Formatting Into VBA Code Button

[Dean P.]

I have several conditional formatting applied to my worksheet (Chicago)
within the spreadsheet. I would like to drop the Excel conditional
formatting and create a Excel VBA button that would apply the same
validations as the condtional formatting.

Listed below are two validations that only correspond to row 6 in the
worksheet (Chicago).

The button with the VBA code should include all rows for the worksheet.

Please help me with the code to complete this task.

Thanks,

Column C is Created with the following format
(=IF(OR(A6<>"",B6<>""),CONCATENATE(A6,"-",B6),""))

(Conditional 1)
=AND(COUNTIF(Duplicate_R,C6)+COUNTIF(Duplicate_E,C6)>1,C6<>"")
(Color Blue)

Column F (Row 6)
(Conditional 1)
=AND((COUNTIF(BTVESS_WELS,Z6)+COUNTIF(BTVESS_WRICH,Z6))
<>(COUNTIF(CANOrder_R,A6)+COUNTIF(CANOrder_E,A6)),Z6<>"--")
(Color Red)

(Conditional 2)
=$T6="X"
(Color Green)