conditional formatting

How can I apply conditional formatting to a range which is dynamic. The start cell is known. The end row is the last non blank row, in the example below, 14. The last column is the last non blank column, in this case, G.

Trying to get if not a solution, then thoughts on this endeavor: To get a cell A formatted, if Offset 1 B to the right of ActiveCell C contains "XYZ". A, B & C is to indicate three sells would be involved: A is acted upon by Conditional Formatting, B is cell evaluated if its value contains...

I am using Excel 2016 Is it possible to do conditional formatting with multiple criteria within 1 rule? Here is what I have - AA4 = TODAY() E4 = Start Date, i.e 14/09/21 P4 = Data validation list, either Education, IWS or Complete I want cells J4: P4 to colour blue where P4="Education" - I...

Hi all, I currently have this setup: My formulas in columns J-M look at their respective counterparts in columns D-G and once all four numbers have been entered in columns D, E, F and G, the cells in columns J-M will highlight which one has the lowest value. However, I would like to...

Hello, I am trying to conditionally format rows C and D so that excel highlights a value when $D94>$C94 (for rows C94:D118). So that when successful, excel would highlight cells D112 and D116. However, it seems that the "<" in front of many of the values in column D is throwing off the...

Hello All, So basically there are several KPI's where the 'Target' Value can vary on a Month by Month basis. I would like to create several Conditional Formatting scenarios that highlights it as Green, Yellow, Red and Blue based on how close the ACTUAL figures are to said Target. At the moment...

Hi to all Is it possible to color a partial text in cell when text is a result of formula (not text written directly in cell)? I know it not possible by Conditional formatting, but maybe by VBA code... 1. I want to colorize name and symbol "!" that comes after name (when symbol appear) to Red...

Is there a way to change the reference cell for all conditional formatting rules in a single cell? I’m looking to speed up a gruelingly redundant process while building a spreadsheet. It will take me over 10 hours the way I’m doing it now. There’s 640 cells and each has 10 conditional...

Hi all, I currently have this graph here: I would like to color the area inbetween the yellow and the red line with an orange color. I would like to know: 1) is this possible, and if so, how? 2) if it is possible, is it also possible to make it do this coloring without pasting the orange...

I want to treat two columns as one and compare rows. I need to look for duplicates but they are dependent on two columns.. I'll try to give a visual example. Number Stage Desc State OP Date 123 Red Hey! ... ... ... 123 Orange Hey ... ... ... 456 Green Cats ... ... ... 876 Blue Dogs...

Hi Everyone! (Sorry this is so dense) I am trying to find a way to use conditional formatting to override my existing conditional formatting, while still retaining it underneath. I want to do this by having the conditional format recognize when I have input a date manually VS. our...

Hi all, I am currently trying out this formula: Copy of my formula: =if(A5=Left(A5;5)="Bob G"OR(A5=Left(A5;5)="George G");"This formula works!";"This formula does not work!") Essentially, what I want to achieve is for my formula to return "This formula works!" if the value in cell A5 is...

Hi all, I currently have these values in a larger format from rows J - N. I have made a small example of my data here: I essentially want to swap my "." with my "," in every cell, if applicable. If not applicable, I want to replace my "." with a "," and my "." with a "," Does this make...

(I'm new, please let me know if I violate the community rules.) This follows up on threads from 2019 (January 10) and 2005 (august 12). I used this command -- =CELL("protect",INDIRECT(ADDRESS(ROW(),COLUMN())))=(#REF!) -- in conditional formatting to make numbers red and this command -- CELL...

Hi all, I have this file that was converted from PDF to Excel. I would really like to filter everything in column A by date However, when I do it looks like this: It filters down until row 687 The row looks like this: I have no idea why it stops? It used to stop at points like these...

Formula needed for dates that match or overlap i.e If the start date in column K is less than a end date in column M then return TRUE in column N, otherwise false If the start date in column K is same as another start date, then return TRUE Don't want to highlight any that leave and start on...

1) I am using drop down menu which shows huge list of information spread over 20 columns and shows results maximum till the 50th row 2) The resulted list is variable. Let's say If i choose "AAA" from drop-down, it shows 10 rows, If I choose "BBB" it shows 5 rows, "CCC" it shows 50 rows, etc. 3)...

Hi all, I currently have a very large data sheet that looks like this: In this example, I've just put in a format of: Date,Name,Gender Please note that some of the cells however might only have Date,Gender or Name,Gender or Date,Gender etc. My ideal format would be: Date,Name,Gender...

I've conditionally formatted the table correctly with coloumn E, but I can't seem to figure out how to make the conditional formatting count for the whole row, not just format coloumn E. EFG18325SP-137078018365270756Gianni Versace18326SP-137088011003996766Gianni...

Hi all, I am currently working with a data set that looks like this: I would like a formula that takes all the values in column A, and if they begin with a comma (","), it should remove this So the result should be like this: Does anybody have a formula for this? It would be greatly...