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

wrote in message
ups.com...
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