Thread: IF statement and color formatting for cell B1 for condition in A1

I'm trying to generate a color-background format result in one cell (cell B1
for instance) when a condition in another cell (A1) is met. I've tried
conditional formatting but it seems to apply only to conditions being met the
same cell that is affected.

Hi Rossta,

Make sure the 'formula is' option is selected under conditional formatting
and then something like =$A$1>5 in cell B1 will change B1 to your selected
format when the value in A1 is greater than 5.
--
hope this helps,
MarkN


"Rossta" wrote:

> I'm trying to generate a color-background format result in one cell (cell B1
> for instance) when a condition in another cell (A1) is met. I've tried
> conditional formatting but it seems to apply only to conditions being met the
> same cell that is affected.