conditional format

Hi guys! I am making my grant chart to tracking multiple projects. This picture show the total view. 1) There is a way to highlight the entire row if column A contain integer even or odd number only [1,2,3,..]. I don't want them to highlight the row there is not a integer. [1.1,1.2,.. ] This...

Hi guys, I have tried to add conditional format with EOMONTH function. But I'm not sure what I do wrong, they make the condition that I made but not on the last day of month. In the below picture: The condition should appear on 30Apr and last day of the other month that what I expect.

I have the following. BC33Pos test (dupes)Other field test34113512B34:C35Expression=IF(COUNTIF($B$34:$B$35,B34)>1,IF(COUNTIFS($B$34:$B$35,B34,$C$34:$C$35,"<>")>=2,TRUE,FALSE),FALSE)textNO I would expect each cell to be highlighted, however C35 does not seem to be affected. The theory behind...

Let's say I have a dropdown with two options (A2): Category 1 Category 2 I also have a range of cells given with different phrases: (A4:C5) Phrase A Phrase B Phrase C Phrase D Phrase E Phrase F and also a table which looks like this: (A6:B12) Phrase Category Phrase A...

Good morning, I'm having an issue with setting the formula for my conditional format. Some background information: I receive a report and copy and paste as values to the right hand side of it. Then I update all the figures with formulas to pull in correct numbers from various tabs. I want to...

I would like to extract the conditional format of a cell from another workbook and programmatically recreate it. Is this even possible? The workbook in question has many many conditional formats but it would be very difficult to get the right color codes and formulas from so many cells manually...

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