Multiple Cells Conditionally Formatting a Particular Cell?

[IsABatty]

So I'm using a 2011 version of Excel on Mac OS 10.7 and I wanted to highlight a cell with yellow using the condition that two other cells in a different row have matching values (namely "Amount in Shed" <= "Reorder Amount"). This works fine using the formula "=IF(J8<=L8,1)".

Now, each row represents a particular item in our inventory and this one cell in question is essentially just a status square that would be yellow any time ONE OR MORE items in our ENTIRE stock is at or below the reorder amount.

My question is: is it in fact possible to get the one cell to turn yellow (in this case) when ANY row(s) has fulfilled the condition? If so, how would i do it?

Thanks

 

[IsABatty]

Please disregard my last message. It turns out that clicking on A3 and putting in the formula you gave works fine, UNLESS the Reorder Amt has a symbol/letter in it (e.g. "N/A" or "?", which some of them do). Though it does work even in ranges that include merged super category cells, which is great.

Anything to add that might get around the 'no letters' constraint?

Thanks again

 

[RonB1111]

Please disregard my last message. It turns out that clicking on A3 and putting in the formula you gave works fine, UNLESS the Reorder Amt has a symbol/letter in it (e.g. "N/A" or "?", which some of them do). Though it does work even in ranges that include merged super category cells, which is great.

Anything to add that might get around the 'no letters' constraint?

Thanks again

A few questions to understand the problem better:

Could you explain why the Reorder amount would ever have anything but a number? If you're putting in "N/A" or "?" when you haven't decided what the reorder qty should be, generally it would be a better technique to leave the cell blank and if necessary use another column in that row for comments.

Also, is the "N/A" the result of a formula in the cell and the display shows #N/A , or did you just type N/A in the cell? If it's the result of a formula, perhaps the formula being used in that cell is incorrect and needs modification.