How can I use an IF function to look for specific cell formatting.

T

Tim

I have a large spreadsheet created by another user. Cells with questionable
values were filled with a specific background color. I want to run an IF
function to check for this formatting; then I plan on filtering the
spreadsheet so I only see those rows with these questionable values.

Thanks for your help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
Dealing with a Pivot Table (when I don't want to) 0
External cell reference between two excel worksheets both in One Drive 0
How do I convert shading to highlighting for specific colors 8
Return the filtered value into a specific cell 4
Counting Cells by Format 2
Function for summing or counting cells based on a specified fill color 3
Missing data when using TREND function 0

Top