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

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