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

A

Al hajri

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
 
C

carlo

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
 
Top