conditional formatting formula

I have an enormous range of data (10k rows x 10k columns) with conditional formatting applied to all cells in this range. The range is something like the below, which is a concatenate of the row and column header values: 0001 0002 0003 0004 0005 0006 0001 00010001 00010002 00010003...

Hello I have created a rule to show if (eg) the value in Column B is greater than Column A, but when I use the Format Painter to copy the Conditional Formatting, Excel is using the absolute reference (even if I remove the $). For example, IF B44 > A44, highlight Red. When copied to B45, the...

Hi everyone, I am currently conducting some revenue variance analysis and I'm having a nightmare coming up with a conditional formatting formula that works for each of the 9 lines. Please see image attached. Column K, is how I'd ideally like the % revenue variance conditionally formatted...

Format only visible rows in Conditional Formatting with an active filter. How can I modify this formula to only format visible rows when a filter is applied in Conditional Formatting? The formula is currently...

Hi Guys, I have added conditional format that will highlight entire row if they not contain "." (dot). But I'm not sure how to skip the blank cell.

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...

Hi All, I hope you can help? I am quite desperate! I need to highlight only the 1st instance of MAX value in a row over 5 columns. IE: A1:E1 with the values being: 7; 7; 5; 6; 3. I want to highlight ONLY ONE/THE FIRST instance of the 7. What do I need to add to the formula (which...

Hi all, I will try to explain this as easy as I can. 🤣 I am hoping to get some assistance on how to copy conditional formatting formula rule to cells below with their respective cell references. I am currently building a spreadsheet to track any engagement/ conversations done with employees...

Hi, I'm putting a spreadsheet together that will compare National results with local scores. I think Conditional Formatting is what I need for this, but I'm not sure exactly what formula to use. The attached image displays what I'm working with, and the colour scheme that I need to...

Hi, I wonder if you can help me with a problem that I can't get my head around! I need to change the colour of a font in a cell based on an exact phrase in another cell. Example: Cell A1 contains a date. Cell B1 contains text If cell B1 contains the text PRE, then the text in cell A1 goes...

Hello, I am need of assistance creating a chart. Currently we track performance on paper and I want to digitize but I cant get my conditional formatting correct. I want a line to be shaded green if below goal and where we finished but be shaded red if above goal and shaded where the performance...

I am looking to clean up the conditional formatting as this document will be used on multiple projects moving forward. I am wanting to know if it is possible to have the rule CONTAINING TEXT 'FORMAT ONLY CELLS THAT CONTAIN" for; 'Cell Value contains = $R$8 to instead be Cell Value contains...

Hello everyone, I have a Google Sheet that I need to apply a conditional format to using a formula. If Cell D3 and E3 are blank and cell G3 is greater than 7, then I need cell B3 to highlight yellow. I have attached a screen shot of an example. Any help is much appreciated!