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