For the range K5:K499
can I use FindFormat to see if any cell has a fill colour other than clear, please ?
For the range K5:K499
can I use FindFormat to see if any cell has a fill colour other than clear, please ?
You can't, from the UI. It would be like finding all words that aren't "Bob".
You could autofilter and then filter by color.
Entia non sunt multiplicanda sine necessitate
FindFormat sets the Format option for the Find command. You can set what format to look for, but not what not to look for--that is, you can look for a specific fill color, but you can't look for "anything but clear".
There are ways to do this other than FindFormat. How do you want to use this?
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks