I have a very large spreadsheet that shows sales data influence between two customers. Whether it be the customers billing location and shipping location or a contractor/oem and the end user. In the spreadsheet, it gives the influence customer (where $$ are flowing to for the sales guy to get credit) and the non-influence customer. When we receive the file the influence is pre-determined, however, I have a formula that automatically flips the influence to the non-influence customer based on certain criteria.
Now, in this sheet I created a conditional format that highlights the row when clicked. The cells change color based on the criteria result in one cell.
This is what the conditional formatting for the row looks like without VBA.
Formula =CELL("row")=CELL("row",A9) Pertains to Cells =$A$9:$X$10001 color bright blue cell highlight
Formula =AND(CELL("row")=CELL("row",XFA9),OR(AND($B9<>$J9,$A9=""),AND($A9<>$J9,$A9>""))) Pertains to Cells =$I$9:$N$10001 color red cell white font
Formula =AND(CELL("row")=CELL("row",A9),OR(AND($B9=$J9,$A9=""),$A9=$J9)) Pertains to Cells =$I$9:$N$10001 color green black font
BilltoShipToscreenshot.png
Is there a way to convert this to vba?
Thanks so much!!!!
Bookmarks