highlight cells

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!

Hi Gurus, Good day! I just want to consult if there's a VBA way to combine the data (get the sum) of specific accounts? For example I have long list of data but need to combine the total data for Math & Science. Note that there are negative numbers sometimes and Reference 01 is the main...

Hello all! So here’s my scenario and/or “is it possible” - I work for a mortgage lender and I’m trying to find an excel spreadsheet or create one that would highlight cells based off employment dates. This would also help to show overlapping or then even show no formatting or highlight red if...

Hello, in my workbook i have 3 sheets, 2 contain data (Sheet 1 and Sheet 2) and another references specific cells on those 2 data sheets. the reference sheet looks like this is there a way (prefereably without VBA) that i can highlight the cells in the data sheets (sheet 1 and 2) that are...

In the following I have some code I need modified to see if I can do the following: 1) Only have this work when selecting a cell inside a couple sets of ranges. Ranges are E9:DA56 and E59:DA106 where I would like it to be active. 2) Only highlight or outline the cells above the...

I have an excel file with some sort of planning. I can't find some sort of idea on google or this forum if this is possible, so here is my question. The planning is for every month, and every month has 4 rows (see added screenshot). Row 1: Weekday names (in Dutch) Row 2: Weekday numbers (in...

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

Hi, is there any way to highlight the cells in a range, if: the value is more or less than 0.2 to the nearest 1 there are already a formula in each of those cells in the range, which will change according to what i change at the other cell. example: if cell value = 6.09, highlight if cell value...

I am trying to highlight rows in if the values in column C and D contain an exact value from column ‘N’. The Values in column are like below: R1179555 R1180259 R1789852 So, if any rows in column C or D contain any of the exact values in column ‘N’ highlight the row. For example: Value...

Hi Guys, Can you possibly help me on this? I'm trying to create a macro wherein in Column A, I need to look for these words Football, Basketball & Tennis and will replace as Sports. In column A as well, I need to look for Math and Science and replace as Subject. I have below codes for the...

Hi, New to the forum I'm here cos i'm stuck with a task. I have a spreadsheet with a list of dates and non dates in column A In column B I want to color highlight cells (so that they can be overwritten with other text) I want to show in column B 1) dates from column A that are greater...

Hello. What I intended is for the cell in Column C to be highlighted if the value does not match with cell in Column D. The cells in both columns are not in the same row, so to know if it is matched is with respect to Column B and Column E. (i.e.C6 will be highlighted but C5 will not be...

Originally Posted by kamranyd View Post Code: Attn_Name = .Range("B13") If Len(Attn_Name) = 0 Then MsgBox "Please enter receiver name", vbCritical, "Quotation Receiver Name Error" Range("B13").Activate ActiveWindow.ScrollRow = 13 Exit Sub End If...

Please help! i have a spreadsheet i put together for a Manager (see below) Each column (H,M,R) represents locations on a job we need to close out. I used "CONDITIONAL FORMATTING" > HIGHLIGHT > DUPLICATES"..... showed to my manager, he loved it and wanted to know if we could highlight the...

Dear Excel Experts I adapted a conditional formatting Macro for my purposes. It works now with an inputbox quite neatly and highlights the cells where the keyword is found. However, I want to hide the other rows where the keyword isn't in. I don't know if that's even possible with this code...

Hello guys, I am using a time keeping file I need to monitor daily and make sure the team is recording their time in the office (company policy). The team is working 7 days per week and we have 2 consecutive free days (blank cell in time keeping). Theoretically there should never be 3...

I have a large report with about 300 districts on it. Each week, this report is burst out to the field, with each district getting only their stores. I do not do the burst (don't know how, to be honest), so I didn't realize this was happening When the file is burst out to the field, the...

Hi! I’m trying to find a simple solution for my Excel VBA script. Sorry for my bad English in advance..:) There is an excerpt from my code. Sub TEST() Range("E2").Value = Application.WorksheetFunction.CountIfs(Range("G4:G1000"), 100, Range("J4:J1000"), ">0") End Sub It puts (in E2 cell) an...

Basics: The column letter is static (something like column NX:NZ); the numbers of rows for a group can change. The math I want to perform would be positioned differently for each group. Details: I have data like the seen below – my sample shows three groups of various lengths, with one or more...

Hello, I'm trying to find a way to highlight cells that do not contain either a y, n, or o. I've tried conditional format but can seem to figure out how to have excel search for all 3 letters. thanks