conditonal formatting

In column A, I have a list of names and I need to find the names that only show up once or twice but not more than two times. I have tried different variations of =COUNTIF($A:$A,$A2)>2 but it just highlights the first and second entries, even if there are three or more in the list. Is there...

Hey Guys, I have a certificate column and its helpful to have the start date and the end date but id like to be able to use conditional formatting so if the date range is within 5 days of expiring its orange and if its expired its red. Here is the data A1Certificates201/12/22 -...

Hi All, I am trying to make a Gantt chart with a twist! I wish to split each day into AM and PM sessions. However I am looking for a formula that will work with conditional formatting, such that if the time is between 00:00-11:59 the cell is highlighted, and when the time is between 12:00-23:59...

Hi all hopefully someone may be able to help i have a 6 workbooks.1-5 contain the data from the different offices about the times they are working. I import the data into workbook 6 onto different worksheets. i displaythem in a Gnatt style chart which i have created using the following Formula...

Hello, I have an index/match formula in a cell on a sheet named "Overview by Specialty". The information is being pulled from a sheet named "Consolidated". I am trying to figure out how to keep the formatting from the consolidated tab. Conditional formatting would require an infinite number of...

I am trying to ensure that there is only one entry per day per area. Column A is the date of entry. The areas are a list "Anodizing", "Tumbling", "Cleaning", and "Passivation". Which are entered into Column B. I could pretty easily use a macro to do this, but if I can just use a conditional...

Hi all, I have written 3 separate macros in a protected workbook which are running successfully, however I have 2 additional functions that I'm unable to get working. I have explained below what my macro does (in a nutshell) to give context to what I need to add in. 3 existing macros I am...

Hi all, Does anybody know how I would code a macro to conditionally format any cell that is >255 characters? The conditional format could be anything but I think changing the cell colour/font colour to red would be the best option. Here is a simple example of what I am after: <tbody> Apple...

Hi all, Firstly, as always, apologies if this has been answered several times already! I have searched and tried various answers to no avail so now seeking professional help!?!?! :rofl: Basically, all I wan't to do is change the value of one cell based on what is entered into another. To be...

Hi All, First post and couldn't find an answer with the exact solution. I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth. Here is a small example of the data I...

Hi All, First post and couldn't find an answer with the exact solution. I am trying to pull numbers for a date range of check-in data per hour per day. For example I'd like to see on 6/1/2015 how many people were checked in at 2 pm, 3 pm, 4 pm, so forth. Here is a small example of the data I...

Hope you guys can help me. I have a training record for my team which list all of the training they have received. Most of the training is mandatory annual training. I'd like to be able to highlight the cells depending on when the training is due with a traffic light system. Red, overdue...

Good evening all, I have a column named Remarks. I want to apply conditional formatting for those cells which have the following text strings in that. How to do this ?? 1. Cancel 2. Cancelled 3. Invoice Cancelled 4. Invoice got Cancelled Thank you

Longtime lurker who couldn't figure out/find a solution to my problem. For simplification, I have values in column A from A8:A16, but I only want to format A13:A16. I have the cooresponding values in which I want to compare A13:A16 in nonadjacent rows and columns I want to look at A13 and if...

Hi, I'm trying to use conditional formatting to colour a cell, based on a comparison of two different cells. For example, A1 = 6 and B1 = 5, colour C1 green if A1 > B1 or red is A1 < B1. In the third cell I'm using the ABS formula to determine the difference between the two cells. I have...

Hi everyone, Hope everyone is well. I have a quick question about conditional formatting. So I have a drop down list in cells A1:A4. The list contains the choices B, C and D. If choice B is made, I want the cell in the next column (and same row) "B2" to me conditionally formatted with a red...

Hi I have a few weird situations with conditonal formatting in 2007. I want to change the formatting on a group of cells depending on the contents of a different cell. For exampe "=OR(C25>0,C26=TRUE)" applies to range: "$C$27:$C$31" However, 1. Sometimes it does not work until I either...

I need to do some conditional formatting. I am using the formula selection. My formula contains more than 3 conditions. What is the work around in Excel 2010 not using VBA method.

Can someone help me plot a conditional cascade chart using the table below: <TABLE class=MsoNormalTable style="MARGIN: auto auto auto 5.4pt; WIDTH: 322.95pt; BORDER-COLLAPSE: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt" cellSpacing=0 cellPadding=0 width=431...

I am using excel 2007. I have a formula in cell J12 that produces a number from a list depending on what the value is in C8. But, I need that number to be negative (formatted red with parentheses) if cell J11=0 and L11<0. I know I can do the RED part through conditional formatting, but how do...