conditional formatting

I have several ranges of cells on multiple sheets that I have manually applied both Conditional Formatting (CF) & Data Validation (DV). However, only some ranges actually work. I've also tried this by recording a macro for the CF and then using the macro to save time and avoid any errors. When I...

Hello Excel knowledge base I hope you can help me, (I did search previous threads but didnt seem to find an answer but it most likely is there) I have a table with a date in column D and I want to put a formula into the corresponding cell in column H that will show the number of months between...

B3 Conditional formatting>Highlight cells rules>Duplicate values shows duplicate even if there is no identical values

Good day everyone, I have an academic rating spreadsheet where students are ranked in the top 10%, 15% and 40%. So right now 3 conditional formatting rules. Each category of rating is recognized during their graduation and on their final graduation certification. However if the student has any...

I have an daily inventory record which shows daily sales quantities and inventory replenishments. When daily inventory reduces to less than or equal to (8), replenishment occurs adding (8) more to inventory. The replenishment process takes (14) days though, and I want to indicate the day...

Hi guys, I've been trying to find a way to adopt conditional formatting for a cell which contains today's date. I've been able to do this successfully, but if I include other text in the cell (for example, a time - see image attached), the conditional formatting does not work. What would be...

I've been unsuccessful trying to figure this out using multiple resources so I'm reaching out here. I'm trying to be make the explanation thorough and apologize if it runs on too long. Sheet 1 has everyones scores by hole who played the last round. The Cells with front 9 scores go from E to...

Hi, I've been trying to find a way to use conditional formatting for a the header if the column for that table contains non-numeric characters as I come across this happening when receiving exported data. I have tried using ISTEXT and ISNUMBER together with an IF statement but haven't gotten...

Hi, I've been trying for a while to figure out a way to use data validation and/or conditional formatting when entering Swedish social security numbers (personal id-number) to check that the value is valid but can't get my head around it. I found an old thread on a forum that has been shut...

I know this seems simple but I've been researching this for a few hours and I'm come up blank. I'm looking to do the following two things with conditional formatting. I need a cell in Row B to go RED if the planned end date has passed and YELLOW if the planned end date is within 14 days of the...

Hi there, I'm trying to figure out a way to clear cells without clearing the applied Conditional Formatting rules from those cells. Here's my code: Sub WipeSheet() ' ' WipeSheet Macro ' Wipes all entries in the sheet besides formulas ' ' Keyboard Shortcut: Ctrl+Shift+W ' PopupPrompt =...

I am trying to create a conditional formatting rule to highlight the first cell in the row with a value (or that is not blank/null). See below. See below - I would like the formula to populate as noted below. The spreadsheet is trying to list projects by weeks and hours. I would like each...

Hello, I am trying to highlight all duplicated combination of 2 cells. Both cells are always numbers and I would like to see if there is already the same combination without adding a new column. An example is: 20 50 20 30 20 50 15 4 I would therefore need Excel to highlight 1st...

Hello everyone, I can't figure out how to accomplish following task: I would like to use conditional formatting to color certain cells based on how big is the difference when comparing two cells above each other. Looking at the example below, Row 2 is the starting value and Row 3 is one that...

I have a code that organizes raw data into multiple sheets, without getting into too much detail, it lists the task from the raw data with short descriptions, and completed date as well as scheduled date for each of the tasks, if the task was completed late (after the schedule date) I want it to...

Hello, I have a spreadsheet on Sharepoint that I'm trying to make work. The purposes: To allow people from our building can add their name and birthdays. To have conditional formatting that automatically highlights all rows containing dates from the current month. To automatically populate...

I was trying to provide conditional formatting in my Gantt Chart. However, I have difficulty developing a formula that will trigger to highlight the cell or range, as the date is not a usual one. I'm hoping that someone from this group can help me solve the issue. I manually provided the colors...

Hi, we have the following sheet where we want to use multiple conditional formatting Sheet is ABCDEFGHIJ1DateOrderDateP NameTGQtyRecd. DateRecd. Qty24/27/1087634/27/1050027/04/2010TEST 129/4/20105504/27/201050045/9/1020009/05/2010TEST 216/5/20102005/20/201015055/9/1015009/05/2010TEST...

Hi all, I want to highlight cells when the row has 5 consecutive (or more) "Need attention". I only want to highlight cells with a word of "Need attention", and only if there are at least 5 consecutive word of "Need attention". The cell values are from a formula. Thank you in advance.

I am trying to use conditional formatting for multiple cells. For every Friday, I would like to highlight red the ones that is our off Friday. I use a table of dates that I want to match against to highlight the red ones. Only one day gets highlighted. I thought I read that I can use the one...