Conditionally format another cell?

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

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

thanks!!!
 
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"
 
Back
Top