Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I convert conditional formatting into explicit formatting? | Excel Discussion (Misc queries) | |||
Conditional Formatting does not convert HTML | Excel Discussion (Misc queries) | |||
Conditional Formatting using code | Excel Discussion (Misc queries) | |||
Conditional Formatting using VBA Code | Excel Programming | |||
Conditional Formatting a Button | Excel Programming |