How can I use an IF function to look for specific cell formatting.
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. |
Hi
see: http://cpearson.com/excel/colors.htm "Tim" wrote: 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. |
All times are GMT +1. The time now is 05:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com