Referencing cell colors...

[JDKExcel]

Hey, guys. Without getting into details, I work for a military arms room with a lot of weapons. I am using multiple sheets for inventory. On one, I have cells labeled for the slots and have it set up with VBA where each cell changes color according to the status of the slot (for easy recognition). This is done via double clicking the cell because it is the quickest way I can think of doing it. I've been trying to figure out, to no avail, how to reference that cell color on one sheet to another sheet to basically do the same thing (linking with names) and sum it up for a total of what is in and out. More than willing to clarify what I'm explaining... have a nice day!

EDIT: To further clarify... currently, the cells are set up with conditioning where instead of double clicking, I manually enter IN or OUT and this changes the color. The text in the cells are then referenced to the other sheets and this works, obviously but is a little time consuming. I can't do everything on one sheet because I'm talking more weapons you can wrap your head around.

 

[Weaver]

Welcome to the board.

counting coloured cells is tricky. Counting conditionally formatted cells more so, unless, that is, you know the condition. Then all you need to do is count the instances of the particular condition.

In this case, you ought to be able to count the instances of "in" using

=countif(A1:A100,"in")

amend the range where appropriate, of course.

HTH

 

[JDKExcel]

Yep, that is pretty much how it is set up now (I inherited this sheet from someone before me). I was just wondering if you can reference the color. Imagine the calender with all 365 days together as the slots. I have to at least hit "I" or "O" to enter in or out... now imagine 3 years of the calenders... and you're still not even half way there to the amount of weapons I need to deal with. The colors are in red and green to have a quick visualization of what is currently in the room. I'm just going to assume there is no way to reference the cell color and I'm stuck with the process I have.