Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
#VALUE in cell but pop up function box show right number | Excel Discussion (Misc queries) | |||
Cell Formatting | Excel Discussion (Misc queries) | |||
conditional formatting blank cell | Excel Discussion (Misc queries) | |||
copy a cell value not its function | Excel Discussion (Misc queries) | |||
Function to return colour of formatted cell | Excel Worksheet Functions |