Hi experts,

I was wondering if there's a quick code to colour all cells with formula in that equal "" as nofill/empty/white

For this particular case I cannot use conditional formatting.

In my spreadsheet in range Q16:Q500 I have sporadic values of 1 and 2 separated by blank cells (By blank I mean a formula is in the cell but it's returning ""). The 1's and 2's require a colour so I'm after VBA code which turns all the formula filled "" blank or white

Does that make sense!?

Thanks for any help