conditioal formatting

I have a table with cell value (Codes) in column "E"and date value in column "I" and because of these codes might be duplicated many times while I need only maximum two cells can be valid with the same code based on the date value in "I" if >=TODAY(). so I need a help please to check if there...

I am making an index of a large number of files and folders. My objective is to be able to modify the background color of all those cells that correspond to a folder, that is, that the path does not end in the file name and its extension. I have tried to use the conditional rules that Excel...

Hi all, Can I please get your help. What is the formula to achieve the following on a pivot table. Highlight cells which are not the same value by ignoring only blanks cells and cells with a single value. I only need to highlight cells where the number appears more than 2 times and when its...

I've been using conditional formatting in Excel for years and I was pretty sure that I had an understanding of the order that the rules were applied. However, I am confused based on the text "Rule (applied in order shown)". I figured that the rules would be applied from top to bottom. Here is a...

Can someone help me with VBA code that does the following. I will explain what I have been doing manually in the sheet. will apply conditional formatting to highlight duplicates in column A. Will filter "yes" from column B and then will filter by color of red from A (highlighted ones from...

Hi all, I have a table of sorts with months running across the top and then days running down the left. The months are the first day of each month but formatted to show the just month in "mmm" format e.g. 1/4/18 is Apr. Down the left is just numbers i.e. 1-31 and formatted as such. What I...

Hello all, I am having an issue with the Formula1:= I would like my conditional formatting to be dynamic. this code will be connected to a macro where it will repeat the conditional formatting however may times the user wants along a series of columns. if this code starts at b9, and a...

Hello there. I want to sort a coulumn of numbers in 3 colours, so I was trying to use conditional formatting, but I can't seem to get it right. I managed my own rule with a "3 colour scale" but as I apply it to selected coulumn, nothing happens. Do I maybe type the rule numbers wrong? This is...

Hi All, Very new to VBA. Wondering if anyone can advise on a macro code to highlights cells based on their value? Basically want to run a macro that will look in column J and highlight every cell that has a numeric value above 40,000. Regards, UMac

Hi Mr Excelians, I have some conditional formatting in a list object (table). They are almost 6 or 7 conditional expression based formatting. Each time I am adding or deleting any rows to/from the table, these conditions duplicated and their area changes. I want a way to have a neat and clean...

Hi, If column C value is equal or less than 80% of column F value then paint yellow column A value. Is this possible with conditional formatting? Thanks a lot!

Hello, I want to conditionally format columns based on quartiles. I am able to conditionally format single column at a time but I have more than 100 columns to format. It's time consuming to edit cell values for each column. So how I can put condition in conditional formatting which is...

This is a long shot but I'm hoping someone can help and that the calculation I'm trying to make can run in excel. In brief, I work in HR and we need to create a new way to calculate holiday pay using extracted data (into excel) from our payroll system. Holiday pay for 200 of our employees...

So im making an inventory sheet and i would like for a cell (the whole row would be great) to highlight a color so im having trouble writing the formula im trying to make it so if the number in cell "B" is lower than "C" and "I" = Yes it highlight the cell(or row if possible) <tbody> A B...

Hi guys, all I want is to set up a format where if the value has a triplicate or more it would highlight. Seems simple enough and this was my formula, =countif($K$5:$K$30,$K5)>=$M$3 where M3 is 3. Or i tried =countif($K$5:$K$30,$K5)>=3 but neither seems to work correctly. Could someone let...

Hi there, I can not determine what my issue is, but I need a solution fast!! We Concatenate() 4 data points to creat a 17 digits text field for lookup. In using conditional formatting for duplicate values and a Sumifs() formula for totalling dollars, it is treating "09961254123882001" &...

Hello This should be a simple one but I just can't get it to work. I opened a new workbook and simplified the data to check that I could get the formatting working on anything for a start. This is the simplified version.. A B 1 Z Z 2 Y Y 3 Z Y I have put the...