can conditional formatting on one cell value to another cell valu
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
|