VBA Conditional Formatting

[msawyer]

Hello,

I need help producing some VBA code for conditional formatting. I've attached a spreadsheet for an example. I would like to format the "Size" cells red when there is a number in the corresponding "Qty" column but no available size in the "Size" column. The example spreadsheet should help explain this better.

Thanks!
Michelle

[fredlo2010]

Hello, try this code.

Please Login or Register  to view this content.

[msawyer]

Thank you. I think this will work. What would I need to change to start the Range in column K?

[fredlo2010]

here

Please Login or Register  to view this content.

[msawyer]

Excellent! Getting closer. I found a few other issues I need to resolve.

1. If a row of data is removed, I would like the red fill formatting removed as well. I have the code in the worksheet on SelectionChange.
2. I would only like to highlight cells in the "Size" columns where there is a number in the "Qty" column but no size in the "Size" column. If the Size column has a size value but no quantity in the Qty column, that is okay. I've adjusted the example and posted again.

Thank you for all your help!