conditional format help

Hi all, I am trying to set up a conditional formatting rule where cells in one column will colour fill based on the value of the top cell in that column. My example is: =$E5="WFH" Applies to: Cells - E7:E12, E14:E25, E27:E38, E40:E51, E53:E58 I have the following in the 'Applies to' box -...

Hello :) I am using excel to demonstrate supply Vs demand, with regards to project resource capacity. What I am trying to achieve (using conditional formatting), as a look up between two sheets, that identifies IF (name) in Sheet 1, has a capacity less than usual in Sheet 2, then highlight the...

Hi all, I have a cell in one tab (we will call tab 1) with a formula in it that presents the data like this: 232 +126.9%. The formula to get this data pulls data from other tabs within the sheet and separates a value and calculates the percentage increase from last year. I need to conditional...

Hi All, I need some help with a formula. In Column A I have the persons name, Column B i have the start time of a persons shift. In column C i have the end time of that shift. The shifts can be any back to back combination of 5 minutes from 7am to 8pm so there are a total of 156 possible shifts...

I have a column in excel of multiple dates and some blanks, I need to highlight the cells different colors based on their date range calculating from Today. Example, cells with no date a certain color, cells older than 1 day but less than 6 months a certain color, cells older than 6 months but...

I am looking to highlight cells in a column only if the values of the cells in the neighboring column are greater than or equal to a certain number. Additionally I am only looking to highlight the 10 smallest numbers in the column. For example: Highlight the 10 smallest values in column A only...

I'm trying to figure out a formula that will conditionally format another column than itself. Ex. I would like the conditionally formatted column to be column O but search column L for cells that contains a date between columns K and M. Columns K and M are start and end dates. The Between...

Excel conditional formatting question. How does one use the green up arrow/yellow dash/red down arrow icon set? In a column like to display the green arrow if the number prior is smaller, the dash if the number is the same or the red arrow if the number prior is larger. Thanks all.

I currently have a workbook with two worksheets inside of it that has some of my clients names in both. Some matching, and some missing. I would like to use conditional formatting (or some other search method) to search "Sheet A" for names not found in "Sheet B" and highlight/format these names...

I have read a few and seek to understand. My sheet will have <tbody> A B C 1 Training No 2 Onsite 22,000 3 Remote 15,000 4 T&E Included 0 </tbody> I would like rows 2-4 to be shaded with dark gray if cell C1 = No so the person will know to ski the whole section. If Yes, the...

New to macros..I am trying to colour format cells using macro as manual formatting it's increasing the file size. Want to see if can build a macro that colours the cell range basis of value obtained from current date and format the list of data with respective colours till the last row data is...

Hello, I would like to conditionally format a row of cells to highlight green only when the last cell(completed date) is populated. How do i do this? Thanks Cal16

I am trying to conditionally format a (fairly) large section using a formula. In the example below, I have rows that may or may not have a total number. If there is a number in the total column, I want the Item name to bold. I am trying to figure out an easier way to format without having to do...

I would like to have one cell equal another cell depending on what number is typed in. For example, if A1=10, then I would like A2 to equal cell C4. However, if A1=9, then I would like A2 to equal C5. And so on so forth (I need 10 circumstances) Please let me know if you need more...

Im trying to teach myself the more complex side of excel by making an attendance sheet for my job. But am stuck on this. So how do a make the cells that contain either PN or PM green and those containing XN or XM red?

Hi, I was wondering if anybody could help me on here, I have scoured the Internet for solutions but none quite solve my problem. I use a 2007 excel sheet to book products in and out of work. There are two sheets in the workbook, sheet one for booked in and sheet two for booked out. As I book...

I am trying to build conditional formatting for a report I run daily. There are certain criteria that I want to "pop" out drawing immediate attention. I want build it so that the variables in column O (several) are true column W (several) are true and Column if Blank =AND($O1="BR- PAP New...

This is actually two questions. I have a spreadsheet containing dates in every five columns in Row(2) begining at (F2) and ending on (BDI2) Question 1: How do I get Conditional Formatting to format the adjacent four cells proceeding the date? Question 2: How can I automatically Scroll to...

I am a little stuck on with conditional formating. I have a table table that i'd like to format. Specifically a row of cells (E14:K14) that i'd like to highlight if cell (D14) is listed in a range of cells on a seperate tab (C12:C43). Do i need to do an if statement with a match statement? I...

Hello, I am trying to pull a few different things together from different sources and getting nowhere. I need my conditional formatting to be dynamic and allow me to add rows when I need to (The in-excel version makes new rules and gets messy with conditional formatting). My understanding is I...