sparkytech
Board Regular
- Joined
- Mar 6, 2018
- Messages
- 96
- Office Version
- 365
- 2019
I have a simple VBA request that I need help with. I want to fill cells down in column "AA" starting at row 5 with "X" if any of the cells B:F are not blank. For example, if any of the cells in B5 to F5 have data, fill AA5 with an "X." If row 10 (B10 to F10) is completely blank, clear cell AA10.
As a bonus, I would like to clear the "X" in each row (column AA) in realtime if anything in the same row (cells B:Y) are changed by the user.
Basically, column "AA" is a flag to conditional format / highlight rows when changes are made to the row, although I don't want or need the conditional format in VBA, so that it remains "mobile friendly". Its setup right now so that if a row doesn't have an "X" in AA, it highlights the row.
Can someone help with this? Thanks!
As a bonus, I would like to clear the "X" in each row (column AA) in realtime if anything in the same row (cells B:Y) are changed by the user.
Basically, column "AA" is a flag to conditional format / highlight rows when changes are made to the row, although I don't want or need the conditional format in VBA, so that it remains "mobile friendly". Its setup right now so that if a row doesn't have an "X" in AA, it highlights the row.
Can someone help with this? Thanks!