Hi there,
I have a spreadsheet where i enter a lot of volumes for various departments. Some departments have sections i don't need to fill in any volumes. I have set it up so that these particular cells are conditionally formatted to the RGB colour 0,0,0 (or black). This conditional format is by using a formula, so sometimes the cells change based on another cell.
Is there a macro i can use so that if the cell has been conditionally formatted to black, the cell is skipped over automatically when i enter in the volumes?
Please note that i don't manually format the cells to change black, i'm using the "conditional format using a formula" option in the formatting option, so sometimes the cells that were black will change to white so that i can enter data into that cell the following month.
I hope this makes sense and someone can help.
Thanks
Bookmarks