Hello all,
I’m having a hard time coming up with a specific line of code in my update macro.
I want an IF statement that is true when the cell has no fill, but false if it has any color fill.
This is what I have so far:
Using the current formula, the IF statement is always true even when there is a colored fill in the cell.Please Login or Register to view this content.
BTW the fill is based on conditional formatting, don't know if that matters or not.
Any help would be greatly appreciated.
-Oli
Bookmarks