Dear Gurus,
I tried the VBA to hide the row if the range of cells e.g: C2:E2 are blank and the macro hide all rows if they find the conta of cells = 0 . But the issue that I want to keep those row that is blank but have at least one cell with color in back groud + comment.
1- Can I do that in VBA?
2- Can I check the empty range instead of counta cells in above condition for hide the rows?
Best regards,
TQV