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

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

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

On Nov 15, 4:00 pm, Al hajri <Al
wrote:
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

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