Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
REFERENCING cell reference
I have formulas that refer to the values of 4 total cells c27-c30...
Hence, each cell can only take on 4 values... How, besides the value, can it take upon the cell background as well??? (c27-c28 is green, c29-c30 is red)... I have tried: a.) The GET.CELL function. b.) and vba code.. but can't seem to get anyone of these right!!!! PLEASE I NEED YOUR HELP!!!! Any ideas? (conditional formatting doesn't work, because the values in these cells are actually symbols , c27 and c28 are an up and down arrow respectively in green, while c29, anc c30 are an up and down arrow with the background in red. If you try to do conditional formatting... it won't work because a.) you have 4 conditions, and b, the values are actually two, up and down arrow... Any help???? ) |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
REFERENCING cell reference
You can get the background color of a cell using the Interior.ColorIndex
Property for each cell in Range("C27:C30") sColor = "Neigher Red or Green" if cell.Interior.ColorIndex = 3 then sColor = "Red" if cell.Interior.ColorIndex = 4 then sColor = "Green" msgbox cell.Address & " color is " & sColor Next -- Regards, Tom Ogilvy wrote in message oups.com... I have formulas that refer to the values of 4 total cells c27-c30... Hence, each cell can only take on 4 values... How, besides the value, can it take upon the cell background as well??? (c27-c28 is green, c29-c30 is red)... I have tried: a.) The GET.CELL function. b.) and vba code.. but can't seem to get anyone of these right!!!! PLEASE I NEED YOUR HELP!!!! Any ideas? (conditional formatting doesn't work, because the values in these cells are actually symbols , c27 and c28 are an up and down arrow respectively in green, while c29, anc c30 are an up and down arrow with the background in red. If you try to do conditional formatting... it won't work because a.) you have 4 conditions, and b, the values are actually two, up and down arrow... Any help???? ) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Referencing relative to a formula reference | Excel Worksheet Functions | |||
Changing sheet reference to cell reference | Excel Worksheet Functions | |||
absolute cell reference A spreadsheet cell reference that does no | Excel Discussion (Misc queries) | |||
problem with cell reference in =sum(offset(cell reference,x,y,z,a)). Want cell ref to be variable. | Excel Worksheet Functions | |||
Problem with =sum(offset(cell reference,w,x,y,z). I want cell reference to be variable | Excel Worksheet Functions |