can conditional formatting on one cell value to another cell valu

Can Excel conditional formatting be done by comparing the value in one cell
to the value in another cell value

Yes it can. Instead of 'cell value is' in the CF dropdown, use 'formula is'.
The formula would be something like =(A1=C1) if you wanted to format A1
conditionally on it being equal to C1, for example.
--Bruce

"Ring eye" wrote:

> Can Excel conditional formatting be done by comparing the value in one cell
> to the value in another cell value

Bruce, Thanks alot, I was not putting parenthesize around the formula. it
works great

"bpeltzer" wrote:

> Yes it can. Instead of 'cell value is' in the CF dropdown, use 'formula is'.
> The formula would be something like =(A1=C1) if you wanted to format A1
> conditionally on it being equal to C1, for example.
> --Bruce
>
> "Ring eye" wrote:
>
> > Can Excel conditional formatting be done by comparing the value in one cell
> > to the value in another cell value