Conditional formatting depends only on the value of the cell, not how it
got there (e.g., formula or manual entry).

In article ,
"scott45" wrote:

Ok I see how it works but I guess I didn't explain my question. In cell say
B1 I have a formula. Can you still use conditional formating? Say the formula
is in b1 and it doesnot equal what is in cell a1 can I have it change colors.
First tip was great thanks

"Duke Carey" wrote:

It's on the Format menu, under Conditional Formatting..

To use it, select cell B1, then go to Format-Conditional Formatting
In the first box select Cell Value is
In the second box select Not Equal to
In the third box type =A1
Click on the format button and choose the attriubtes you want, then OK your
way back to the spreadhseet


"scott45" wrote:

Is it possible to have a cell change color if say the value of cell a1 is
different from b1. I have read about this conditional formating but to be
honest I can not find it under format cells. What am I doing wrong?
Thanks in advance