ExcelNovice
Well-known Member
- Joined
- May 12, 2002
- Messages
- 583
Hi all,
I need a conditional formatting code that will remove the grid lines from each cell in the range H2 to J45 if the cell is empty. If the cell is not empty, the conditional formatting should provide border outline for each cell with content. Finally the conditional formatting should color each row that is not empty with an alternate color blue then red.
Hope this makes sense....thanks.
I need a conditional formatting code that will remove the grid lines from each cell in the range H2 to J45 if the cell is empty. If the cell is not empty, the conditional formatting should provide border outline for each cell with content. Finally the conditional formatting should color each row that is not empty with an alternate color blue then red.
Hope this makes sense....thanks.