conditional format

Is there any way to create a function in VBA that will count all red coloured cells in a Table? My table, named Input has 11 columns and starts at cell A6 (A6 being the first column header). See attached screenshot. Above columns, ID / Date of Birth / Delivery mechanism / Review reason /...

I wanted a 2023 calendar w/ consecutive dates. I would like it if I could Conditional Format cells whose dates contain Even Months. Like so: I tried to figure it out, even from an old 2006 post from here, but my brain is fried. Thanks in advance!

Okay, the table below is an example of what I need but not sure how to write the formula/what setup would be best. I am trying to figure out the best way to make the status column work correctly. For each row: if Date 1 is 1 day or less before Date 2 = Red Status if Date 1 is between 2 day and...

I'm trying to use conditional formatting to compare a static value with a dynamic value that will be updated daily. Whenever I try to use the conditional formatting, it compares to the first cell chosen rather than the one it should compare to. The table will contain 50 items if not more...

Hi, I have made a sheet to check results from a water test against a limit. I started with one column where you insert the results from the test. And if the result is higher than the value written under Grenseverdier Bærum Kommune then the cell becomes red, if its under the cell becomes green...

Hi, Im looking to create a VBA code that help me check my results for each region (Range A2:P9) against the limits of that region Range(G2:G9) Results in Region 1 if greater than Limit of region 1 then highlight cell will color red. same goes for other regions Request VBA code for the same...

I have applied formatting conditions to a range of cells on the spreadsheet as shown in the image. I have VBA code which evaluates format conditions and outputs based on them. The problem is that when the conditions are applied in this way the VBA code pulls the formatting based on the first...

Hi, I'm basically looking for a VBA that- - identifies duplicates across the whole workbook/multiple sheets - highlights duplicate cells to same random colour (preferably a light colour so text is still visible) - ignores blank cells Any ideas? Many thanks,

Hi. I used VBA code from this post and it working good, but have one problem... Function CommentText(Cell As Range, Txt As String) As Boolean Dim x As Comment Set x = Cell.Comment If x Is Nothing Then CommentText = False Else CommentText = x.Text Like "*" & Txt &...

Hi everyone, I have added another word to my dropdown menu and condiational formatting so I can clear expired dates when they are complete. Currenlty when I choose Completed from the drop down menu it removes the pink highlight from the date so I know I don't need to chase them up. I am...

Hi everyone. I am trying to conditional format the **Paired-up Table** according to the result of the Paired column. The "BoyA" column reflects the Row number of the Paired-up Table, the "BoyB" column reflects the column number of the Paired-up Table. For example: If the value in the...

I've read similar formulas and threads, but I'm not skilled enough to apply it to my current situation. A sample of my data would look like the attached picture. Hopeful someone can lead me in the correct direction! Trying to use Conditional Formatting to highlight rows with duplicates in cell...

I am trying to format cells based on dates, with the first priority being the first rule "green" then simply color coding the rest of the cells based on dates. I keep getting cells highlighted with rules that don't meet the criteria in the original cell. For example, Cell H9 should be Green...

Hello world, so I have the sheet as seen in the attachment (I have included a picture) I have 2 columns, A for machines, B for products. I want to highlight those products that are created from both machines , so something like if duplicate and column A in the range of the duplicates contains...

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