I think I have a bizarre question to ask. I have a row of numbers in
row 1, in row 2 I have inventory, is there a way to have a conditional
format in row 1 about row 2? for example I have 12 months, column A is
Jan, B is Feb, so on. The inventories in row 2 are depleting by month,
meaning the next month will have less than the previous since they are
being used up. in row 1 is the cost of the inventories in row 2. row 1
column A would be jan price for inventory in row 2 column A...make
sense so far? I would like to have a conditional format where when the
inventories in row 2, whereever in the year hit 0 or less than 0 row 1
(the price row) will be highlighted. As backwards as that sounds can
that be done?

Ryan