conditional formatting based on values of another cell

Is it possible to apply conditional formatting on cells based on the
values of other cells. For example, if value of O3 on sheet 'Data' is
between 1-10 then make the background of cell L2 on sheet 'Inventory'
red. Likewise, if same cells 11-20 apply blue and if same cells 21-30
apply grey? This would be applied to 30 columns and approx 450 rows?

Thanks
Tony

Conditional formatting does not normally let you set the criteria on another
worksheet or workbook. However, you can get around this in your case by
giving Data!O3 a name (Insert/ Define/ Name). Let's say you name the cell
"O_3". Then on your Inventory sheet, Conditional Format, select Formula is
= O_3 < 11 apply red
= O_3 < 21 apply blue
= O_3 < 31 apply gray

Mike F

<[email protected]> wrote in message
news:[email protected]...
> Is it possible to apply conditional formatting on cells based on the
> values of other cells. For example, if value of O3 on sheet 'Data' is
> between 1-10 then make the background of cell L2 on sheet 'Inventory'
> red. Likewise, if same cells 11-20 apply blue and if same cells 21-30
> apply grey? This would be applied to 30 columns and approx 450 rows?
>
> Thanks
> Tony
>

Nice one Mike

Cheers
Tony