How do i set up a formula that fillcolor the cell if ....?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'd like to know how to set up the formula to fillcolor the cell ??

if (e.g...) the data in Coluom 12 is matching the data in Row 5 then the
results is fillcolor the excat cell
 
I'd like to know how to set up the formula to fillcolor the cell ??

if (e.g...) the data in Coluom 12 is matching the data in Row 5 then the
results is fillcolor the excat cell
Click to expand...

Select column 12 with the first row active.
Then go to Format => Conditional Formatting
there you change "Value is" to "Formula" and
enter =E1.
Then change the cell format as you wish.

hth

Carlo
 
Back
Top