Convert Conditional Formatting Into VBA Code Button
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,C 6)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) |
All times are GMT +1. The time now is 11:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com