Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |