conditionalformatting

I have been trying tirelessly to change the color of cells based on the color/data of a cell in the same row as that cell. I keep seeing things about a VBA, but I don't know much about that. I have tried multiple different conditional formats, and nothing has worked. There is already a...

Hiya, I have edited the Gantt chart template from Microsoft to highlight cells based on the week number rather than the date, as this is what our company uses for projects. When a project runs over two years, the gantt chart then repeats itself , see image red circled areas. This has happened...

How do I highlight values that appear at least three times with matching value in different column? For example below I would like to highlight values in column C that appear at least three times and they have matching value in column A. Right conditional formatting with right formula should...

<tbody> Leader Employee Week Ending Avg Hours Worked AA Mr. Smith 06/30/2019 4.5 AA Mr. Smith 07/07/2019 5.75 AA Mr. Smith 07/14/2019 4.25 AA Mr. Smith 07/21/2019 5.0 BB Dr. Brown 06/30/2019 2.0 BB Dr. Brown 07/07/2019 2.5 CC Mrs. Taylor 06/30/2019...

Hi All, Got alot of data and only interested in the references which have a latter in the 14th character. For example, the references are LLLLLLLLLLLLLL, and say LLLLLLLLLLLLL9. Im only interested in the data where the 14th character of this reference is a letter (LLLLLLLLLLLLLL) and not a...

Hi There, I am struggling to conditional format a cell to change colour based on comparing two dates against one another and against a time frame, for example: Cell A1 Reads 27/01/2016 Cell A2 Reads 10/02/2016 I then want Cell A3 to change colour based on the below information:- If Cell A2...

Hi all... hoping someone can help me! I have a question about conditional formatting. I have created a dashboard with a tab where I need to change the conditional formatting based on a drop down selection. This is because there are different average benchmarks for each selection. For...

I would like to create an IF statement that uses a conditionally formatted cell as the logical test for example: =If(A1has conditional formatting,1,0) Is this possible? "No" is almost as helpful as "yes and here is how" for me. Thanks in advance.

Hi all, I currently have a very large sheet of information and a sheet with a Pivot table. Let's say Sheet A and Sheet B respectively. I of course want to bring the information from Sheet A over to Sheet B, however, I have duplicates on Sheet A that I want to disregard on my Pivot Table. I'm...