colored

Hi all, I am currently looking to apply a conditional formatting for this specific situation: - If I enter a plain value in a cell, let's say "10", the cell is colored red - If I enter the same value but via a formula calculation, let's say "=2*5" or "=A3*B4" with A3=2 and B4=5, I would like...

Hello, I hope someone can help me. this has been driving me crazy for a few weeks. I have 2 sheets, one named inventory and another named orders. on the orders sheet I want to be able to do a vlookup to the inventory tab and display the qty in stock, but then if the same item is listed on...

Hello, Today I have been given a task to reformat a massive, 36 sheet long excel file that has pretty messy organization. This is a screenshot of the original excel sheet: http://www.screencast.com/t/iVh0qWx5fCuk And this is how the formatting should look like...

Hey there, I am trying to find a formula to match a colored cell with value of the cell next to it and display that value in a separate cell (copy). Here is an example: <tbody> A B C 1 1/14/2018 6 4 1/15/2018 6 1/18/2018 7 1/19/2018 </tbody> So if we have something like this (red...

Hi everyone ! I have an idea to count automatically red and black colored cells data from different sheets. Anyone have an idea about some formula ? Thanks.

Hello, I have a list of around 25,000 names that are in a document that I call "Main List" in column B1 to B25000 that I call and start with blanks cells in column A1 to A25,000. The column A is used to be filled with a color, either red, yellow or green. Every day, some people will send me...