I have below formula in one cell, lets take example A10
in above formula it copies value from cell CE from Port-3-Script, as 95th column is mentioned in formula
Please help me in getting solution of below problem
1. I want along with values...
I am unsuccessfully trying to speed up my un-highlight selected cells macro. I have been toying with the code to speed it up as if I mistakenly select an entire row it takes a long time to complete. But I am too useless and have failed to get it working correctly. I have also been...
I was wondering if anyone could help me.
I have provided an image, so illustrate what I mean.
As you will be able to see I have a column labelled PM - this column has the initials of project managers. When I enter the initials it will automatically fill in a color. This has been...
Hello, i use excell 2010
My conditional formatting so far will color code names e.g. all cells that say mike have a blue fill color.... no problem that was easy.
But i need the cells to the left of my names column to have the same fill color, e.g. cell f2 is blue and says mike, and i want e2...
I am trying to conditionally format a cell based on other
conditional formatting in a range of cells.
I would like cell E3 to be:
Red if any cells (O3, T3, Y3, AD3, AI3, AN3, AS3) are Red
IF NOT THEN
Yellow if any cells (O3, T3, Y3, AD3, AI3, AN3, AS3) are Yellow
IF NOT THEN
Green if any...
I have successfully (with help from this board) been able to conditionally format cells based on their proximity to a due date (green, red, yellow). What my manager wants is if we get behind (and the cells turn red) but then we catch up again, if all of the cells can change to green...
How would you Excel gurus do this?
I set the background color of a cell to be of a certain color by using basic functionality in the "Home" tab.
I now want the cell adjacent to it to be 10% lighter, and the next cell along to be 20% lighter, etc.
So if the first cell is coloured a dark red...
I would like to create a traffic light (Red amber green) so that i can monitor for whether things are on track for a deadline for major projects. ie. I wish to be able to select a drop down that says 'Late' under for example 01/11/2013, but all i want is for the box to turn red. and the...
Is it possible by conditional formatting or VBA code to check down a column in "B1:B300" and if any cells are black then color the cells next to it in column "C" and "D" black as well. :confused:
Thanks in advance
I created a button to color selected cell(s).
I would like to have a macro which does the following:
Where do I apply the formula?
The formula is first applied to the cell range "A1:Z1" (part of a row).
Then, I would like to apply this formula to each row from "A15" to "A2189"...