Set Range Color - No Fill


How do i set range color in excel to No Fill? I have Tried Color.Empty but it just makes the selected range black.


I’d suggest to use Color.White, as this is same color you’ll get from get color from empty cell but it will lose the grid lines.
Another solution I can think of is to create a macro to clear fill, and use Execute Macro activities by calling the macro name.

Ajeed Rahman

Are there any better solutions to this issue? It seems very inconvenient to not have the option to simply “no fill” a cell instead of being forced to fill a color, even if white.