Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=cell(color,a1)
if A1 format = F2- =cell(color,a1) displays 1
if A1 format = G =cell(color,a1) displays 0 =cell(color,a1) therfore does not refer to the cell color but rather to the format Is there a way to determine the cell value of a cell color? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=cell(color,a1)
You have replies in your other thread. Don't keep starting new ones.
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Fris" wrote in message ... if A1 format = F2- =cell(color,a1) displays 1 if A1 format = G =cell(color,a1) displays 0 =cell(color,a1) therfore does not refer to the cell color but rather to the format Is there a way to determine the cell value of a cell color? |
Reply |
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) | |||
Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
How to change the default Border, Font Color, and Cell Color | Excel Discussion (Misc queries) | |||
Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) |