| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check Font or Font color and take action
This might be off the wall, but I will ask anyway.
I have 4 cells A1 thru D1 with numbers 1,2,3,4 respectively. E1 = sum of A1 thru D1 = 10 Is there a way to examine the font style or font color of each of the 4 cells to determine if that cell's value can be part of the E1 sum? So if B2 font color = red, then it would not be part of sum E1, therefore E1 = sum of A1,C1,D1 = 8. Appreciate any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format for font color using font color | Excel Worksheet Functions | |||
| Changing Font color based on font type or size | Excel Discussion (Misc queries) | |||
| how I can Check the color of font in excel cell ? | Excel Worksheet Functions | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| Why is first font action v-e-r-y slow? | Excel Discussion (Misc queries) | |||
Threaded Mode
