conditional format color

I'm in O365, and I know this shouldn't be this difficult, but for some reason I'm struggling. I need to format a column based on due dates and % complete. Column A is % complete, Column B is Due date. Anything that is 100% complete in Column A, regardless of date, would be green. (Complete)...

Please kindly help me look into the attached Image, on the header columns is numbers 1 - 49 with Red, Blue, Green colors and 49 is a yellow color. You will also see that the combined numbers also has 1- 49 Number as the top numbers all across the rows. My question and problem now is; how do I...

Hi Everyone, I'm stumped. I am trying to use conditional formatting to turn a specific cell red, if a certain date is found in an associated cell. In my head, it was simple: Column A has a series of names (A2 to A12). Each name has a row of dates associated with it ranging from columns B to...

Hi! This wonderful forum helped me out a while back with a work project I just could not figure out. I am back again with a similar work project that is throwing me for a loop and was hoping you guys could help me learn where I am going wrong. I'm not understanding something about my...

What I need to do is to count the number of conditional highlighted cells in each row (range) for each color. Ultimately, if the color exists in the range, I intend to have a value of 1, else a value of 0. Here is a worksheet with an example of what the result should be for the first 5 rows. It...

Hello, Thanks in advance for your help! I am looking for macro/vba to help highlight a range of cells within the quarter/year columns if date value falls within baseline start and baseline end? baseline start baseline end 2021 Q1 2021 Q2 2021 Q3 2021 Q4 2022 Q1 2022 Q2 2022 Q3 2022 Q4...

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 all, I am trying to write a script that will highlight the cell adjacent to the highlighted cell. Here is what I have come up with but throws an error: Sub if_highlight() Dim c As Range For Each c In Columns("B") If c.Interior.Color = Excel.XlRgbColor.rgbYellow Then c.Offset(...

Hi, I have a very basic question about plotting data in Excel charts. My data contains two columns representing date and quantity and a third column which contains categorical values (see sample data below). I need to create a simple column chart with date on x-axis and quantity on y-axis and...

Hi All! I need to translate the following data validation rules to VBA: Rule 1: Cell does not contain: no blanks format - as white -- stop as true Rule 2: =OR($J3="Pending - Please Elaborate in Notes") as red Both of these formatting rules apply to $K2 through $K1048576 I am...

Hello! I'm trying to find a way to set a Conditional Format for Column A based on text or color of another cell range. More specifically, my target range is $A. If $B through $H is either grey (it would be grey based on other set Conditional Formats), or contains an "X", I want Column A to be...

Hello all, 1st post here so I will try and be as descriptive as possible. Appreciate any help! I'm using Excel 2018 and I'm trying to get conditional formatting to show an arrow pointing up in green and an arrow pointing down in red. I do not want to fill the cell with color, I only want the...

I have a spreadsheet where in Column C the CELLs are filled with a mixture of text and numbers. I am wanting he text to highlight in a colour when text is entered and the numbers to remain black. Example Column C3 has Email typed - This would turn red. Column C4 has a number - 1234 - This...

I would like to use conditional formatting to highlight cells that have an actual date and time after the originally scheduled date and time. For example, column 4 row 3, the delivery time is 18 minutes late - I'd like to highlight that. And in row 4, it's a day late, that would also need to...

Hi, I'm wanting to make some dates within a spreadsheet change depending if the date is older than six months (turn red), is two weeks before the six month deadline (turn amber) or is within the six months (turn green). I can get the dates to turn red and green but it is the formula for the...

Hi Guys, I run a few golf pools a year and have a pretty good spreadsheet that automates a lot of stuff (now if only I could tie into alive leaderboard). One of the things people want to see is their lowest 7 scores highlighted. I can total the lowest 7 using the SMALL function, but when...

Hi Everyone! I am hoping someone can help me here. I am at my wits end with this project. So I have two different conditional formatting by formula rules in place. The first is...

I am trying to assist someone with reconciling all of their business financial information into one excel workbook. It has become a little complicated now that I have worksheets for bank information, time keeping information, and multiple quick book exports. I have noticed that the check...

I have a sheet that has multiple lines of data and in many cases there are repeated lines because I am linking headers and lines. For example: A B C D E F Contract Customer Name Contract Date Charge qty...

I am working with 3 columns and need the following things to happen: 1) If a cell in column F contains a date, the cell in column G should add 5 business days to this date (due date). Column G should be empty if there is no entry in column F. 2) If the date in column G has passed, the cell...