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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top