J
jack
I have a function in which I can calculate the result differently based on
some input parameters. I would like to visually know which calculation path
I am selecting by setting different background colors. I see the examples
and have checked through these postings but I cannot change the background
color of the cell. I have moved the sheet off to its own xls file and
totally simplified the code:
Function Test1()
Sheets("Sheet1").Range("A1").Interior.ColorIndex = 4
Test1 = 6
End Function
The Test1 = 6 is just so I can verify that the function is being executed by
changing the 6 to other numbers.
I have tried:
ActiveCell.Interior.ColorIndex
RGB color settings
Selecting a Range and setting it
I have Protected the sheet and set AllowFormatting
Is there something that I need to set somewhere?
some input parameters. I would like to visually know which calculation path
I am selecting by setting different background colors. I see the examples
and have checked through these postings but I cannot change the background
color of the cell. I have moved the sheet off to its own xls file and
totally simplified the code:
Function Test1()
Sheets("Sheet1").Range("A1").Interior.ColorIndex = 4
Test1 = 6
End Function
The Test1 = 6 is just so I can verify that the function is being executed by
changing the 6 to other numbers.
I have tried:
ActiveCell.Interior.ColorIndex
RGB color settings
Selecting a Range and setting it
I have Protected the sheet and set AllowFormatting
Is there something that I need to set somewhere?