conditiaonal formatting

I am trying to build a spreadsheet that has multiple condition. When I plug in my conditions into conditional formatting, it won't work. 1st condition: I want 3 rows to be filled in blue, with border and vertical lines highlighted, one line no fill/border, then the next 3 rows to be no fill...

I am building a scheduling table with start and end times ... which then populate a "timeline" across the business day. The business day is a series of columns in 15 minute increments starting at 05:00:00 AM to 10:00:00 PM. The timeline fills the cells between the start and end times entered. I...

Afternoon, I need help with conditional formatting. If cell c10 is red i need J10, q10 and x10 to also turn red how do i go about doing this. Thanks Eve

Hi All, I'm trying (and failing) at getting excel to automatically insert a Note based on a specific cell value. i have my conditional formatting set up so that when a WBS code is inserted it changes to a specific pattern/colour, that is working fine. what i want it to do is to insert a note...

Hi, I'm trying to find a way to highlight a cell by using conditional formatting but need help. I'm trying to highlight cell V4 if there is a Y in cells D4:U4, can anyone explain how I go about achieving this? Many thanks Evie

Hello, I am trying to have excel create a tracking link based on which carrier an employee selects in Column G and the tracking # in Column H. Since each carrier tracking has similar link formatting, I would copy their link, but just need to change the tracking # part of it ... for example...

Hello, I'll start by saying I'm a little past novice with the power of Excel, but also not super intricately skilled—so hoping someone with more knowledge can assist! I am trying to have excel create a tracking link based on which carrier an employee selects in Column G and the tracking # in...

I created a calendar, I would like the days of the calendar to be formatted based on the profit or loss for that day. I figured I could have a query table that takes all the data from my main dataset and groups/sums the P&L by day, and then reference this table in a formula to format the...

Hello Ex(cel)perts, I hope you can help me with the following issue. We have large excel files with ascending numbers. B1aktenummer21324354657687981091110121113121413151416151716181619172018211922202321241252263274285296307318 If you can see is on row number 17 and 18 the same or double...

I've written the below which shades days on a calendar in grey, depending on whether the days fall within the "Start" and "End" range, however I would ideally like it to be different colours depending on who is in the "Assigned To" column e.g. light grey if it's "FACULTY", dark grey if it's...

Hello Forum, I have a workbook with alot of sheets. To easily check if any inspection is due i want my tab color to represent the most critical status to be shown. I tried piecing together some code but nothing really worked for me. In my column of inspection due dates i need to search for...

The attached XL2bb Mini Sheet shows in cell A1 the number 21 which is the next blank cell in B column. I would like to use conditional formatting to highlight the entire row based on the cell number that appears in A1 as a visual guide to open, in this case, Bogus 20 file, to get file content to...

Hello all, I was hoping to get assistance in the following matter. I am trying to track employees certification compliance. I need to conditional format dates based on different expiration time frame. for instance, employee A has a cert with the completion date of 14 May 19 but the cert has to...

I have one workbook. I have a data entry sheet where users can enter data (A3:H866) - vertical orientation. I also have a summary sheet (AB6:AM90) - horizontal orientation where I have used an Index formula to bring in values from the data entry sheets. The expectation is that if there is a...

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???" how to possible Conditional Formatting ????

I feel embarrassed to ask this question but I have searched for a solution and can’t find the solution. I have several dates in Column H. I want to format cells that have dates than are 365 days or older Red. I want similar formats for cells that are between 365 days and 180 days Orange I want...

Good time of the day to you all! I have a problem with conditional formatting and really hope that someone could help :) In the below table the formatting needs to be applied to the columns D, E, F and it should be based on the values in columns A & C with the following condition: if cell D4...

It's easy to copy the value of a cell. If you want to automatically copy the value from A2 to B7, then in B7 you type =A2. But can something like this be done with cell formatting? I use a spreadsheet to track our work, and we color each item based on who is handling it (every person is...

Hello, I am trying to do some simple conditional formatting to change the colors of some cells based off the value of one of the others. My "NewRow" variable works for statements before my If statement so i know thats not it. The cell "(NewRow,18)" will be related to a radio button later on so...

All, I have a Pass/Fail column, B. In B2 I have three radio buttons, Pend, Pass, Fail. My need is to 1. Have multiple rows in column B with the same radio buttons. There may be skips. So for example, B2-B10 will have the radio buttons. B11 will not have the radio buttons. B12-B20 will have the...