| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can I use text color to set up a formula in excel (Red text = -1)
If you knew the exact color index or RGB combination that made up the RED
text you might be able to do it, but it is an extremely dangerous way to write your code if you are looking for accuracy. I would suggest you try a different type of flag that is easier to control for input by the user. "gypsyatheart" wrote: I would like to create a spread sheet that when something is written in Red text in a cell that it will subtract one from the total. Is Excel able to do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using Text color as criteria in formula | Excel Worksheet Functions | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
| Excel formula for counting text in a certain color? | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
Hybrid Mode
