can conditional formatting on one cell value to another cell valu

R

Ring eye

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

bpeltzer

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
 
R

Ring eye

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