Easy Conditional Formating Question

M

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.
 
J

Jim May

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