conditional formatting formula

I am trying to figure out formulas to create conditional formatting for dates that take into account the current date and its relation to future dates, and that are not limited to specific months, years, or number of days. I would like these formulas to be able to carry over into future years...

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!