LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Test the color of a cell

Hi,

I would like to make a SUMIF on cells formatted is some ways (font,
background color, character color, ...)

So it would only sum the cells that are written in dark blue for example.

I hav searched but didn't find any function to test that, but I know there
should be one because I can make a 'FIND' on those cells.

Of course I'll have to know the color codes or names ..

Thanks for your help,

Xavier


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TEST CELL COLOR MrBill Excel Discussion (Misc queries) 1 April 29th 10 02:56 AM
Can I create an "IF" function using cell color as a logical test? JessLynn Excel Worksheet Functions 1 June 25th 08 08:09 PM
Test cell interior color by worksheet function? Skimmer Excel Worksheet Functions 7 September 4th 07 09:40 PM
If statement to test font color Gary Excel Discussion (Misc queries) 5 May 24th 06 09:09 PM
Logical Test comparison using cell color chamuko Excel Discussion (Misc queries) 2 November 9th 05 03:09 AM


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"