conditional formatting

Hey all, I asked a question similar to this the other day, but have changed my approach and wanted to get some input. Based on the date ranges in the table below, is it possible to use conditional formatting, or VBA, to color cells a solid color. Even better, if possible, can I use a gradient...

Hi, I'm looking to find a way to highlight rows within this range (not entire row), based on the following two conditions: If any date in column A is a weekend, then highlight that particular row and/or If any cell value in Column B at min. contains the word "TEST" (doesn't have to match...

I've had issues with conditional formatting extending beyond the range it's defined for (for example, conditional formatting is defined for A3:G3, yet it also formats cells outside this range like A4). It seems to get triggered by the existence of conditional formatting in adjacent cells (but...

Hey guys, ** Context ** I work in television advertising, where we have to make sure that none of our spots (ie. the times when our ads are showing) are playing on the same station (channel) within a 16 minute interval. Each week, we copy all of the spots (often tens of thousands) that we have...

Hi all, I currently have a list that looks like this (albeit much much much larger in reality): I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...

I need to conditionally format a column based on the text in 2 other columns and am just wondering what the best way to reference the entire columns in my formula would be Here is the code as it stands =AND(A1="MARIA1",C1="PORTUGAL: Segunda Liga") So if I wanted it to apply to all of A and...

I'm looking for assistance in setting up a macro to do the following. 1. Add a blank row in between each set of value from Column G. Column G is named "Handler (Job)" and may have different values on different tabs. Let's say it comes looking like this - Bob Susie Susie Lauren Bob Lauren...

First of all I would share my data but it contains personal information about patients so I will abstain. I will preface through: in my role I receive many reports containing patient data and there is a lot of manual leg work to go and tell where the fallouts are. In this specific spreadsheet we...

I've basically got a column of names. I want to highlight duplicates. Conditional formatting works well, but but many cells in the column = "?" as a place holder. Obviously this will get flagged as a duplicate as well, but I want to take any cells that = "?" out of the running. So, basically...

Hello! I have a a big dataset where I've used the conditional formating to color values that are grouped as: The values are in percentage of the total in that specific dataset, so all values are somewhere between 0 and 1. Above 20% : green traffic light 19,9% to 5% : yellow traffic light and...

Hi all, My column C contains "Graduation Dates" and D contains Call Status (whether I have called). I want my conditional formatting to highlight my column C cells based on the following ideas: No formatting if date is far out Yellow for date is next week so I know I'll need to call soon Red...

I have a sheet with various conditional formats, I have noticed sometimes when copying value only into the work sheet that sometimes the conditional formats work instantly and some times i have to click into the cell and click back out to get it to pop. is there something I can do to get them...

I'm trying to use a VBA macro to assign conditional formatting as it needs to be done over several different excel documents. I have three columns, for the project name, if it is started and if it is completed. What I want if for the project name and started column to change to orange is started...

Hello, I am trying to define a VBA MAcro for Excel 2019. I have a reasonably big dataset in which every column (variable) has numbers with different scales and meanings. Would like to automate conditional formatting so to loop through each column in the range of interest, identify empty cells...

Have a sheet with multiple other conditional formatting rules in place that work fine, but I can't seem to get this one to work. Each row tracks an email so I need the entire row to highlight if something needs to be done. Some emails require they be sent by paper to other parts of the building...

Hi All Please advise on a VBA code which i can use with Index Match for conditional formatting. my conditional formatting formula is as below =(Combined!$A2=INDEX(Summary!$A:$A,MATCH(Combined!$A2,Summary!$A:$A,0))) I want to highlight cells (any colour) if any cell in Column A from the...

Hello! I am trying to use conditional formatting to highlight the blank cells in a database, only if there is data in other parts of the row. For example: if a cell in Column B has data then highlight the blank cells in that row from A to R. Here is an example of my data: In this...

Hi all, I currently have this setup: My VBA code is this ( credits to @RoryA :) ) Option Explicit Private Const FilePath As String = "\\UBSPROD.MSAD.UBS.NET\userdata\t684895\home\Documents\faq folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i...

Hi all, I have a sheet with an email in cell A64. I am trying to create a macro that will send an email to this email, but when I click my macro I get this error: and debug highlights this: Did I not do it correctly? What do I need to fix? Thank you all! BR. Jyggalag

Hello, i am trying to get this conditional format down to where on my sheet on cells D16 and E16 are greyed out and or also crossed out of the cell b33 = "Last" on sheet "Check Off". Thank you in advance!