Next dumb question.

[RCB]

It has been a while since I asked a dumb question, which is to say it's been a while since I asked anything.
Here's what I troubled with.
In Excel 2003, I'm trying to use an "IF" formula to change a text color in one cell based on a value from a cell on anothe worksheet.
selecting A1 on worksheet 2
If cell J3 on worksheet 1 is >1.5 then the text color in A1 worksheet 2 should turn red.
Here's the rub. The value of cell J3 on worksheet 1 is a formula (=SUM(J2*1000)/J3).

Thanks in advance for any help with this one.
RCB

 

[Scott Huish]

You don't use an IF function for this, you use Conditional Formatting.

Define a name for your range on Worksheet 1, I will call it "namedrange"

Select the same range on Worksheet 2, go into Conditional Formatting, and use the following formula:

=INDEX(namedrange,ROW())>1.5

Format as desired.

 

[RCB]

Thanks HOTPEPPER
That did work on getting the text red if >1.5 but for some reason it does not switch back to black if <1.5
I tried a second conditional format to do that but to no avail.
Perhaps I should have mentioned in the first place that this should change as the results change but I guess I thought the formula would do that already. Wondering now if that is why I started out trying that with the IF formula.
Any who. I do appreciate your taking the time to toss me some help.

RCB

 

[Scott Huish]

Worked for me. Are you changing the values on Sheet 1?

 

[RCB]

I am. I am trying to change values in both the cells (J2 & J3)that affect the value in J4. It only changes back to black if I delet the values in J2 & J3.

 

[Scott Huish]

If it's just for J4, try this formula instead:

=INDEX(namedrange,1)>1.5

 

[RCB]

That did the trick, thank you so much HOTPEPPR
RCB