condional formatting

I would like to create Conditional formatting based on the text in each cell. Let's say that each cell contains a list of color names and cell background color should be some sort of gradient between them. Let's say cell A1 value is "blue, green" I want its color to be like in the photo below...

Hoping someone can shed some light on this, I am looking for a macro that would fill all the red cells with the text at the top of their respected column i.e AWV, CPE, CCM etc. I have not yet found anything that can recognize each individual column, always fills red cells with the same text...

Hello, New to this forum, I thank you for your help in advance. I need dependent cells to follow the decimal formatting of a one parent cell. I've done this with format painter but my parent cell decimal requirements changes from time to time and I need the dependent cells to adjust and...

Hi everyone. I've got a formula that's supposed to highlight every duplicate in a column, except for the "F" character. My problem is that only the first instance of a duplicate value gets highlighted unless I type the COUNTIFS range as an absolute reference and I don't get why. The reason I'd...

I have tried everything I have found on conditional formating and I can not get it to work. The data in my cells is generated for formulas so I don't know if that is the problem. I would like to highlight column B based on the value in column C. If Column C is less that 1 or equal to Zero the...

Hi, Thanks again for taking time to look at this. What I am trying to do is change the colour of the above cell depending if an S is in the below cell. I already have a vlookup formula in the above cell which depending on the value will change colour. This is easy to do with conditional...

<tbody> JUL AUG SEP OCT NOV DEC FIELD 1 FIELD 2 FIELD 3 FIELD 1 FIELD 2 FIELD 3 FIELD 1 FIELD 2 FIELD 3 FIELD 1 FIELD 2 FIELD 3 FIELD 1 FIELD 2 FIELD 3 FIELD 1 FIELD 2 FIELD 3 -500 -350 445 -525 -357 225 -285 -337 235 -288 -275 225 100 125 25 75 150 70 250 225 25...

Hi, I am just after a little help in fixing a formatting rule that I have written as a conditional format that I have written for QA work. Here is the code I have written: =OR(AND(SEARCH("missing",K1),M1="No"),AND(SEARCH("lost",K1),M1="No")) Basically I want the format to highlight when a...

I also have another problem with conditional formatting. When I put the following formula in to determine which cells to format it then changes my N/A (from a previous conditional format) to that particular colour too. For this I used the following formula: =IF(AND(b1<=TODAY()-1642,b1>1),TRUE)

I have some code that creates a new line in 3 different tables on three different worksheets in a workbook when data submitted through a user-form. All of the formulae are copied from the line above and all of the data from the user-form writes to the correct locations, but I have a total of 5...

Good Day I am using a spreadsheet with some tabs that are published as web pages so that we can display them on TV`s as dashboards. In one dashboard we have some targets, I am using the data bars from conditional formatting to gradually color in the cell as we progress. It works great however...

Hi ! 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 am using VBA to apply conditional formatting to a column however, I only want the conditional formatting to be applied to cells which already fill in them and skip any cells with no fill. Below is my current code. Sub ApplyBAandCertConditionalFormatting() With Sheet2 With...

Hi All, Probably the hardest thing I've had to do in excel and I need someone with a better skill set than I currently have please! I've put together a pretty big spreadsheet which draws data from ODBC links to a database. Part of the report shows how much has gone out over 12, 6, and 3...

Hello Everyone, I searched everywhere and I can't seem to find the answer to my problem and to be honest i don't know if this is even possible. I run a huge family "NFL Pick the Winners" spread in Excel, about 18 of us. I was hoping I can use conditional formatting to change the color of...

Hi Everyone. I am trying to create a worksheet that highlights SLA acceptance and breaches. In Column F, I have the time an Incident is received e.g. 16:05:00 In Column G, I have the time I accepted that incident e.g. 16:10:00 I need the cells in column G to highlight Green if it's within 15...

Hi there, I'm wondering if there's a way that I can format the text of a sheet so that it will automatically have a specific color relating to the day of the week the text is entered? For example, if I enter the text on a Monday it will be green, if I enter it on Tuesday it will be red, etc...

I am using the following formula to find the total of the 6 largest values in a range of cells... =SUMPRODUCT(LARGE(B45:B54, {1,2,3,4,5,6})) The function is working exactly like I want. However, now I would like to create a conditional formatting rule for that same range of cells so that if a...

Hello)) I am trying to conditionally format my chart. I know that I can do it with "IF" statement (which I do successfully). But I want to format the fill color of my chart bars based on the cells' color (bars take the same color as cells). Something tells me that there should be an easy VBA...

<tbody> dates M T W T F S S 01/27/2017 16 17 18 19 20 21 22 01/28/2017 23 24 25 26 27 28 29 01/29/2017 30 31 1 2 3 4 5 02/02/2017 6 7 8 9 10 11 12 </tbody> Hey! All I want to do is to highlight every day in the primitive calendar on the right that is stored on the left in the...