Get instant live Excel expert help to learn how to combine conditional formatting with IF statement

I have created a gantt chart in Excel, that highlights the cells with a color, according to the amount of days an activity has. I use a Conditional Formatting (CF) formula on a group of cells (=OG(J$6>=$E7;J$6<$F7) ) for that. If the formula is true, then the cells change color. My problem is, that the calendar includes Saturdays and Sundays (weekends). How can I write a formula in CF that will jump the weekends and count the rest of the days on monday. Fx. An activity starts on a thursday and last 5 days, then it shall highlight T, F, M, T and W. In advance, thanks for the help.

Conditional formatting, I have two columns A and B with 50 different rows. Each row could have the same data, or different data. If a value in column A is present in column B I want to highlight that cell grey, if a value in column B is not in column A then I want to highlight that cell white.

i have two columns filled with website addresses. i want a third column that declares if the website in column a is also in column b. i have created a conditional formatting rule so that all the website that appear in column a and column b turn green in column a. however, i want a separate column with only the websites that are green in column a. how do i do this?

I need to use conditional formatting to fit the following: Cell D3: Date of Call Cell E3: Date call returned if E3 is empty, but it is D3 +1 day, turn yellow if E3 is empty, but it is D3+ 2 days, turn orange if E3 is empty, but it is D3 + 3 or more days, turn red if E3 has any date inside, background fill green

Please create a pivot table to give a count of lead source grouped between the following date ranges: 13/12/2017 to 15/12/2017 16/12/2017 to 24/01/2017 25/01/2018 to 21/02/2018 22/02/2018 to 22/03/2018 I will then need to see a month on month %variance, if you could show this using icon based conditional formatting that would be great. Thanks

I want to do some conditional formatting. In column A we have the company name. In columns R to AB we have locations. There is a '1' populated in the field if there is a local office in that location. I want to highlight the companies in column A where: there are more than three office locations noted in R to AB for that company

I am looking at getting a conditional formatting equation set up where it is based off if the cell above is greater than or less than. And I am looking at trying to have this for thousands of cells so I do not have to do it for each individual cell, I could just drag it down or use the format painter.

I want to use conditional formatting using the New Rule> Use a formula to determine... The company is in column A. In the columns R to AB are locations where there may or may not be offices of the company in A. If there is an office, it is marked with a '1'. No office is a blank field. I want to highlight in green (column A) any companies where there are three or more office locations noted in R to AB. It should be applied to the whole workbook.

I need help with conditional formatting to highlight a cell if any of the names appear in a column list of names

How can I modify my conditional formatting with formula that I currently have applied to cells E7 - E16 to instead make an entire given row up to column H red if a cell between E7 - E16 contains a # value that is less than the displayed day # value within the date of the month in cell E4?