![]() |
#1
|
|||
|
|||
![]()
Hi All,
Is it possible to use the text colour of a cell in a range of cells to add the value or not. I.E. if the cell text colour is RED then don't add the value, if the cell text colour is green add the value. What i'm trying to do is have cells filled with expected revenue and when an item is sold to change the colour of the text indicating it is sold and to add it to the totals cell at the end of the row. Any ideas or push in the right direction is always helpful. regards Trevor |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Help with Formula to extracting text from text string | Haha88 | Excel | 7 | 01-13-2019 01:33 AM |
![]() |
Haha88 | Excel | 9 | 02-05-2018 01:04 AM |
Formula to Extract text from a text string | Haha88 | Excel | 2 | 11-14-2017 01:32 AM |
![]() |
Philip | Word | 2 | 03-01-2016 03:19 PM |
Font Colours | fred bionics | PowerPoint | 1 | 10-18-2009 09:53 AM |