condiational formatting

Hi - I have an excel sheet which has numerical data in columns J through AV. I would like to highlight rows where all columns have data as either 0 or blank. How do I achieve it through either conditional formatting or formula? Example below - (In this, I would like to highlight row 2). Thanks...

Hi all, I need help with conditional formatting! I am in the process of making a tracker used to keep track of when certain machines need maintenance. Could someone help me out with creating a formula for conditional formatting that will highlight cells with dates in the month ahead, 2 months...

Hiya All, I have the following formula set in Conditional formatting to highlight the entire row when the town Aston is present. =SEARCH("Aston",$G1) The issue I have is it also highlights cells that contain words with "aston" in them i.e. Glastonbury. Is there a way to stop this? Thanks in...

I am trying to highlight cells using IFS to identify a date range and color code it. This is what I have: =IFS(N:N>TODAY()+179,N:N<TODAY()+366) and highlight background yellow. Any help would be greatly appreciated.

Hi, as mentioned in the title, I'm trying to make a conditional formatting rule where if a cell contains a certain word (potentially in amongst other text in the same cell), the whole row of that cell will be highlighted. Unfortunately I cant quite get the formula right, so looking for...

I am trying to apply the following conditional formatting to a macro. It is creating the formulas and applying them to the correct range, but it is only setting the format for the first formula. Any ideas? This is my code: Sub CondishFormatMulti() Dim MyRange As Range Set MyRange =...

I have a table where each row is a specific Individual ID Number, and each column corresponds to different dates a test was taken for that ID Number. The ID Numbers are in Column B, and the test dates go from Column H to Column AL. Column H is the baseline test, then every test after that is...

I have a bank report where I am trying to highlight the duplicates. The highlight duplicates only works for one condition under conditional formatting. How do I get it to work for more than one condition? In my example, I want to highlight duplicates that are duplicates in the Type column and...

I have an Excel sheet that tracks the amount people have paid each week. I'm trying to make it so that the person's name is highlighted in red if the amount of their remaining balance is greater than it should be. I have no problem doing this portion. My problem lies with the upcoming weeks. If...

I use excel and i have sheet look like : A B C 1 3927269 58516305 2 2356361 3 2749088 4 294545 5 13156350 6 1570908 7 1963634 8 5105449 9 3632724 10 3141815 11 7996358 12 3534542 13...

A kind soul yesterday helped me with a formula for a vehicle maintenance sheet yesterday. I have an additional request. Can someone please help me out with a formula that gives an "MOT due in..." time, but takes into account the fact that an MOT is only due after 3 years? I have added a date of...

Hello, I need some help trying to figure out this conditional formatting. I've tried looking at other formulas and implementing them to my situation to no avail. I have the conditional formatting set up as to have anything that is greater than the max ID to go red, however if the max ID cell...

Hello Experts I Have below Data , i want to give a condition for Jan-23 to May-23 condition Jan-23 - if Jan-23 is greater than Average of Oct-22 to Dec-22 then it's upper direction if not then lower direction for Feb-23 - if Feb-23 is greater than Average of Nov-22 to Jan-23 then it's upper...

Hello, I'm having some trouble combining two Conditional Formatting rules to work across two columns instead of using them individually. Currently, I'm using the following to highlight the cells in the Author and Series columns based on a named range (lstPreferred): Used in Author column (D)...

Hi folks, need some expertise to handle a cell that has both positive/negative values and colour the portion of it. attached is an example. so, a Cell has a string and number, I want the colour green if it is increased and red if decreased. I am doing it manually and it takes ages. any...

Hello everybody and you all do an amazing work. I need your help please and i apologize in advance for any mistakes (English is not my native language). This one is kinda tricky and complicated. I have created a calendar of shorts, where I input the work schedule and put a bunch of conditional...

allow to enter value in cell, only if 1. data contain 1 time "x" value between two numeric value . & both numeric values should not be more than 99, e.g 34x45.5, (allow)...... 21x56.44 (allow) 23c45.5, (not allow). 23 x 45.5 (any space not allow) 101x22 (numeric more than 99 not allow)

I have a Power Automate flow running that adds rows of Associate information into sheets of an Excel online spreadsheet. I would like to set up conditional formatting so that it highlights rows that have the same "Associate Id#" (First column in each sheet) when that ID number occurs three...

I have a spreadsheet I am working on and I need it to highlight cells depending on data from other cells. Here is an example to make it clearer: I want cell D4 to highlight yellow if the following conditions are met. If B4 is greater than C3 and less than E3 turn D4 yellow. Is it possible to...

i have this table: 2022-101 101 1 2022-pzl 101 1 2020-201 102 1 2020-202 103 1 1 101 102 103 i want to conditional format Row 6 if the matching value in column b (ex. 101) is populated in column c and d even if on different rows. (ie: 101 yes,102 no, 103 yes). i have...