Sub that takes the value of a function

[AT--o]

Hi.
In excel 2007.

My function takes its arguments from cells on the same row that it is inserted. I just copy it down. The problem is I need to change the Interior of this cell (the one containing the function) according to values that while taken from operations between the arguments are not the value of the function. (otherwise I would use excel conditional formatting). I know the interior of a cell can't be changed by a function so...

Whats the code for the Sub? Im specially confuse about passing the arguments.

 

[kpark91]

{Cell}.Interior.Color = RGB(0~255,0~255,0~255)

Example:
If you want to color your cell's interior red.
Range("A1").Interior.Color = RGB (255,0,0)

 

[Jonmo1]

You can use conditional formatting to format one cell based on values in OTHER cells..

Selcect "Formula Is" instead of Value is
and enter a formula

So you could color cell B1 based on A1's Value.

Highlight B1, and click Conditional Formatting - New Rule.
Selct "Use a Formula to determine..." from the Rule Type
Enter
=A1="Hello"
Select your format and click OK

Now B1 will change format based on A1's value changing to "Hello"


Hope that helps.

 

[AT--o]

Thanks jonmo1 that will do.