Easy Conditional Formating Question

[magoobee]

I'm trying to compare a cell to another cell. If the cell that I'm setting up the conditional formating is greater than or equal to the other cell then I want the font to change color.

I used "Cell Value is" "great than or equal to" "=j4" j4 is the other cell and selected red for the font color but it does not change color.

[Jim May]

Use the FormulaIs option, not CellValueIs
With A1 active, Format, CD.. FormulaIs
=A1>J4
Select color (pattern)
OK out

"magoobee" <[email protected]> wrote in
message news:[email protected]...
>
> I'm trying to compare a cell to another cell. If the cell that I'm
> setting up the conditional formating is greater than or equal to the
> other cell then I want the font to change color.
>
> I used "Cell Value is" "great than or equal to" "=j4" j4 is the other
> cell and selected red for the font color but it does not change color.
>
>
> --
> magoobee
> ------------------------------------------------------------------------
> magoobee's Profile:
> http://www.excelforum.com/member.php...o&userid=21581
> View this thread: http://www.excelforum.com/showthread...hreadid=511370
>

[Jim May]

Make that:
=A1>=J4

"Jim May" <[email protected]> wrote in message
news:pWpHf.172809$oG.37536@dukeread02...
> Use the FormulaIs option, not CellValueIs
> With A1 active, Format, CD.. FormulaIs
> =A1>J4
> Select color (pattern)
> OK out
>
> "magoobee" <[email protected]> wrote in
> message news:[email protected]...
>>
>> I'm trying to compare a cell to another cell. If the cell that I'm
>> setting up the conditional formating is greater than or equal to the
>> other cell then I want the font to change color.
>>
>> I used "Cell Value is" "great than or equal to" "=j4" j4 is the other
>> cell and selected red for the font color but it does not change color.
>>
>>
>> --
>> magoobee
>> ------------------------------------------------------------------------
>> magoobee's Profile:
>> http://www.excelforum.com/member.php...o&userid=21581
>> View this thread:
>> http://www.excelforum.com/showthread...hreadid=511370
>>
>
>

[magoobee]

Thanks I found if I just removed the quotes my original formula worked.