conditional format

Hello all, Is it possible to permanently apply conditional formatting/custom format on all spreadsheets including the new I open. If the cell value is TRUE, highlight in Green If the cell value is FALSE, highlight in Red Thanks

I am trying to format L3 , but it says the formula contains an error. The formula works if placed in a cell, so I don't know what the problem is.

How do you apply conditional format from the Nth column to the end. Or, to the entire worksheet, except the first "N-1" columns. Or, from cell G1 to the end of worksheet. Example below is from 7th column to end. Also to account for columns being added later.

Is it possible to carry out a conditional format for cells that contain part of a formula. Specifically I want to format cells that have "+2" in their formula, for example "=7+2" will be formatted. I was thinking to convert to text and then scan for the "+2", but don't know how to do this. So...

Hello, First, I want to apologize if my english is not great. I am french and look forward to get tips from you for my project. My wish is to create a conditional format that is not fix to one same formula but a variable format which change for each column and each row... I can make it work...

I am looking to use conditional formatting to differentiate visually between cells which contain ANY formula and cells where a value has been keyed. So, if a cell contains a formula (e.g. '=A2+B2' or '=vlookup(...)'), I want it to change to bold blue font and where it is a keyed value (e.g...

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