| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Color
Thank you very much all of you.
"Darren Bartrup" wrote: Create a defined name (INSERT ~ NAME ~ DEFINE) Call it something like CELLCOLOUR and in the Refers to: box enter: =GET.CELL(24,INDIRECT(ADDRESS(0,0,4,FALSE),FALSE)) Which will return the font colour index of the current cell. Can then be used in a formula: =IF(CellColour=3,"Red","Something else") More help on GET.CELL: http://www.mrexcel.com/archive2/18800/21312.htm http://www.jkp-ads.com/Articles/ExcelNames08.htm "Angeles" wrote: Is is possible to define a condition depending of the text color of cells ? Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
| My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel | |||
Threaded Mode
