conditional format

Hello, I have a file with 2 sheets Named: Holiday Calendar ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ120222BHBank Holiday UK&IBHBank Holiday UKBHBank Holiday IrelandHoliday34January5Carried FwdIn LieuEntitledLeft...

I have a range of dates: K9 = 01/01/2021 K10 = 02/01/2021 K11 = 03/01/2021 K12 = 04/01/2021 K13 = 05/01/2021 I have 5 conditional formatting rules: =IF($B19="PRE",AND(K$9>=$H19,K$9<=$I19)) =IF($B19="PRE",AND(K$10>=$H19,K$10<=$I19)) =IF($B19="PRE",AND(K$11>=$H19,K$11<=$I19))...

I have an error check sheet within a work book, for example EF1PART NUMBERSERIAL (IF APPLIC')212345-6789112233312345-678949876-54321F2:F4Expression=IF('Error Check'!AR3<>"","TRUE","FALSE")textNO Now this works great, but I have times where a new row needs to be inserted within the data. upon...

I have ID's in a column (currently Col K) and Codes currently in Column M. (Columns will be added but Codes will always be two columns to the right of ID. I have the following code but how do I use Offset in the formula to look for an entry two columns to the right? I don't want the formula to...

I want to assign a color to a cell based on there being an event that falls within a specific date range. As shown below, event1, falling within the week of July 4, would cause F3 to be blue, since it has category1. So the cells in range F3:I5 would be colored based on a running list of events...

Hi, I have a spreadsheet that will be used by other people and I have locked all the cells which contain formulae and conditional formatting so that no one can break my sheet. However, there are some columns which the user will free type into and they would like to be able to change the colour...

I need a conditional formatting to highlight column Q. Depending on the columns E (Type of Leave), it will correspond to the available balances in column R(Provincial Leave / Family Responsibility), S(Medical Waiver), T (Bereavement). If column Q is > the available balances, it would highlight...

This is How it's supposed to look in the end. I have no problem with columns T to Z changing colour based on their values, but I can't figure out how to change AB... I'm trying to make the checkmark and X symbols change automatic; if all cells in a row (T-Z) are green, a checkmark should be in...

What I did: I am trying to insert below conditional formatting formula in every sheet of activeworkbook with VBA. =OR(CELL("col")=COLUMN(),CELL("row")=ROW()) I used the below VBA code to apply the above conditional formatting in every sheet with one click. this code do below steps First...

I have a table as below. I need the cell AVG ALL to be conditionally formatted to show the following... If AVG ALL is less than TARGET by no more than 5% then fill colour AMBER. If AVG ALL is less than TARGET by more than 5% then fill colour RED. If AVG ALL is equal to or more than TARGET then...

I have a long list of numbers that are to 7 significant figures. I want to highlight the numbers that end in 00 and 000. I don't want to change their number format or significant figures. For example, values such as 1.2345000 and 1.2345600. Is there a formula for conditional formatting that...

Any idea?

Hello, I'm sure it's out there somewhere but I haven't been able to find it yet. So sorry, everyone, I'm pulling you into this. I have created a worksheet of letter grades and would like to do a conditional format color fill of the cells for every letter grade in the same cell. These grades...

I would like to add a yellow outline to a bubble if any of the three values used to create it are between 50-75. This will be a bubble chart with several slicers so the need for a yellow outline will be a moving target. Any way I can achieve this? My data set up (from a pivot) looks like the...

Hello - I spent the past hour or so searching google and the forums. I can't find exactly what I'm looking for and that's probably because I don't know exactly what I'm looking for. My real goal is to find and highlight cells that did not get summed up. I.e. if I have a sumifs formula with a...

I have a long list of numerical values in a column and I am trying to set up conditional formatting to highlight cells that contain specific values in blue. The values I am trying to apply this formatting to are the following: 200180, 200181, 200182, 200252, 200940, 200065 After doing some...

Hello everybody, I am currently sitting with the following material overview file in Excel: I have made some conditional formatting so whenever I enter a number in column E the entire row gets highlighted. Unfortunately, this erases/makes invisible my dark gridlines/borders from before...

I have a table with a "DATE" column that I generally update daily with the current date, so my current conditional formatting for that column is - Cell Value < TODAY() - (with a green colour), so if the date is from yesterday or beyond then it will highlight green until I change it. But I have 2...

Hi All, I have a spreadsheet which, in column L there is a percentage that is based on the numbers in columns D and G. I would like to create a conditional format that says: -if column L is less than or equal to 3% format the entire row green -if column L is between 4 and 6% format the entire...

Hi, I have a structured table with a certain table style: All of the cells in them are also formatted as "Normal". However my "Normal" is slightly different. It has cell background as white (not no-color), and has alignment OFF. Furthermore, in column Good Listings I have some Conditional...