Conditionally format another cell?

R

Robin

Is there a way to change the background color of a cell based on the
contents of a different cell?

thanks!!!
 
D

Dave Peterson

Just use a formula that refers to the other cell.

If I want X99 to change depending on what's in A1.

I select X99 and then format|conditional formatting
Formula is:
=$A$1="anythingyouwant"
 
Top