**1**

vote

**2**answers

27k views

### Excel conditional formatting if value is between or equal to values

I have been trying to use conditional formatting to create a Gantt chart. So far I have not been very successful. Here is a screenshot of part of the chart:
The current formatting is hand made.
I ...

**1**

vote

**3**answers

1k views

### Conditional Formatting: 3 color scale showing text relevance in Excel for Mac

Is there a way to use conditional formatting in the following manner in Excel? (For those who are curious, I am using Excel 2010 for Mac)
I want Cell B2 to be green when A2 says "John likes green ...

**1**

vote

**1**answer

552 views

### Change Excel Worksheet background colour based on values

Hopefully some one can help, but not sure if its possible. I'm using Excel 2010.
I want to change the background colour of a whole worksheet to green if the value in cell c20 is equal to or greater ...

**1**

vote

**2**answers

26k views

### Excel: Conditional formatting using icon sets?

I would like to format the Subtotal row such that within each Subtotal cell is the total and an "icon set" icon that will show if that month is greater than or less than the previous month's total.
...

**1**

vote

**2**answers

66 views

### Single condtional format rule to apply to a range of cells

I'd like a single conditional format rule I can apply to a range (a columns) so that a number appears in bold if it is greater that the number to its left, like this:
100 200
200 190
200 300
Is ...

**1**

vote

**1**answer

387 views

### How to do conditional formatting based on several criteria? [duplicate]

Possible Duplicate:
Formatting a column based on another columns cell TEXT (not value) in Excel
How can I implement the following as an Excel formula?
If column j="renew" or "-" AND the ...

**1**

vote

**1**answer

482 views

### How to use conditional formatting in excel?

I am trying to make a spreadsheet black out non-needed information for individuals that meet a certain criteria. Their criteria is in column A and I need it to void cells B10:15 through C10:15 and ...

**1**

vote

**1**answer

729 views

### How can I set conditional formatting to check for equality between columns?

I have a dataset like this in Excel:
A B
1 X X
2 X Y
3 Y X
4 Y Y
I want to set up conditional formatting such that rows 1 and 4 will be highlighted as green because their A and B cells are ...

**1**

vote

**1**answer

679 views

### Excel conditional formatting multiple repeating rows

I'm using Excel 2010
I have a monthly menu. menu days are listed by row with 2 menu items list for each day.
Col-C Col-D
Day 1
Cheesburger
Hamburger
Day 2
Taco
Quesadilla
Day 3
...

**1**

vote

**4**answers

4k views

### Excel: struggling to use CF to highlight differences between columns in the same row

I have a list of vaules in column A and column B. I need to highlight where there is a difference between values that are in the same row.
I've used a simpe formula in B1: $A1<>$B1 (format bold). ...

**1**

vote

**1**answer

1k views

### Conditional format - change a cell to specific color based on formula

I need to color a cell in Excel 2007 based on a statement like, if B6=H and C6=g then color A6 Blue
I have no idea what the proper script would be but here is my guess that does not work: ...

**1**

vote

**1**answer

2k views

### Conditional Formatting of a Cell Based on Color Value in that Cell in Excel

Is is possible to format a cell based on one component of the RGB value inside of it. For example, let's say I have 3 cells - A1, A2, A3. In A1, I want the cell color to be the shade of red anywhere ...

**1**

vote

**1**answer

1k views

### Excel 2007 Conditional Formatting is not properly using custom formula provided

In Excel 2007, I want to conditionally color a row if it is odd numbered and then vary the coloring depending on if a specific cell (in column E) in that row contains a number (green) or empty(red). ...

**1**

vote

**1**answer

36 views

### Excel rearrange column using copy + paste

I am trying to create a method to automatically rearrange the column when performing copy + paste.
Say I have an excel file with table containing columns on the first row:
ID | NAME | DATE | ...

**1**

vote

**1**answer

32 views

### Conditional formating of excel row based on the value of the first cell of the row

I want to apply a conditional formating for a row only if the first cell (A column) contains text starting with Volum. Is there a way to do such a thing ? Thanks in advance.

**1**

vote

**1**answer

43 views

### Conditional formatting between 2 sheets

I've got a conditional formatting question I'm really hoping someone can help with. I've got a workbook with 3 sheets - "Total Data", "Pivot Table" and "Expired Data". Pivot Table is extrapolated ...

**1**

vote

**1**answer

126 views

### Highlight Cells with Red Text

I have a column of text in which some characters (not cells) are in red font. Is there any way to highlight the cells which contain red characters via conditional formatting? VBA solutions would be ...

**1**

vote

**1**answer

47 views

### Use Conditional Formatting on a Cell Based on matching a value in a range

I want to change the cell background of a cell (M16) if the number in it matches one of the numbers in a table of random numbers (M3:Q12)
Table of numbers - M3:Q12 Cell I want to format is M16.
...

**1**

vote

**1**answer

322 views

### How to highlight the first cell in a column that matches criteria with conditional formatting

In one column of a spreadsheet I want to highlight the first cell ONLY above a specific number. For example, if a column has values increasing from 0 in the first row to x in the last row, how do I ...

**1**

vote

**1**answer

184 views

### Condition formatting dates two week before the actual target date

I have a spreadsheet in excel with a formula that when I enter a date into column A cells, column B cells will enter a date 9 months - 1 day from the date entered in cell A1, A2, A3, etc... Now I ...

**1**

vote

**2**answers

3k views

### How to highlight calendar cells based on given start and end date

For a while now, a coworker has been using a chart similar to the one shown below and wants to automate it (i've already added the days before/after due date).
The chart is printed or worked on at ...

**1**

vote

**1**answer

3k views

### Conditional Formatting if one time is greater than the other

I'm attempting to get excel to conditionally format a cell based on if it is 5 minutes greater than the value in the column next to it. It's to compare times to see if a person was late to work, we ...

**1**

vote

**2**answers

109 views

### conditional formatting excel 2013

Is there a way to highlight a cell (possibly with conditional formatting) if one of the cells to the left of it has data, but it is empty?
for instance,
A B C D
...

**1**

vote

**1**answer

139 views

### Conditional formatting from another conditional format in Excel

In Sheet X I have a bunch of cells that are conditionally formatted with a fill color. I want the colors from Sheet X to be dynamically updated to Sheet Y and Sheet Z. That is, if cell X:3:D is ...

**1**

vote

**1**answer

1k views

### Conditional formatting for entire row based on fixed column

How do I create the following conditonal formatting:
If the date in G3 is older than today, turn all of row 3 red
So in other words I want my entire row to be formatted based on the value in the ...

**1**

vote

**1**answer

1k views

### Excel conditional formatting based on a formula including a range containing the current cell

I want to change the background of a cell as long as the running total in that column from start to that cell is less than a limit specified in a different cell.
Conceptually, the formula should look ...

**1**

vote

**1**answer

348 views

### Format columns matching drop down value Excel 2003/VBA

I have a drop down in Excel to allow user to select a comparison bank. When a bank is selected for comparison all occurrences of that bank are highlighted in the tables below the drop down. Here is ...

**1**

vote

**1**answer

1k views

### How to compare cell contents in Excel?

I have an Excel sheet. Row number 2 contains date values in each cell. For each cell in the sheet I want to check if the value in row 2 in my column equals some cell (let's say EG67, also dates).
How ...

**1**

vote

**1**answer

3k views

### Alternating Row Colour with Conditional Formatting in Excel 2011 for Mac?

Does anyone know how to create a formula that causes the row colour to alternate when using conditional formatting?

**1**

vote

**3**answers

381 views

### Excel Conditional Formatting for Cell condition in Range

How do I reference another cell in my conditional formatting?
I want an entire range to highlight in green if a particular cell in that range is populated with "y".

**1**

vote

**1**answer

126 views

### Is there a formula that I can use so that I can get a cell on Sheet 1 to have exactly the same formatting as a cell on Sheet 2?

I am using an excel spreadsheet to record skill competencies of staff. Sheet 1 will act as a "master" sheet reflecting the skill competencies of all staff (ie different employee in each column) and ...

**1**

vote

**1**answer

141 views

### Excel 2007 formatting using a range

I'm formatting a calendar on multiple sheets in excel, with the weekends highlighted. I'd like to format all the sheets from a table of 1s & 0s I generated to match different years. Unfortunately, ...

**1**

vote

**0**answers

20 views

### Prevent Excel 2016 from changing Conditional Formatting ranges & “Apply To” ranges [duplicate]

There must be an easier way to deal with this.
| A | B |
|-------|----------|
| Email | today |
| Email | tomorrow |
Here is the volatile method of conditionally selecting any row ...

**1**

vote

**1**answer

39 views

### Why does Excel automatically apply conditional formatting to other cells?

I construct following table in Excel 365:
I select the entire column D and add conditional formatting.
Whenever I fill out an additional row, the cell in column D is coloured and the other ones ...

**1**

vote

**0**answers

34 views

### Is it possible to use conditional formatting in Word 365?

Is it possible to use conditional formatting in Word 365, as it is possible to do in Excel 365?
I know that you can add an Excel sheet inside a Windows document, and use conditional formatting inside ...

**1**

vote

**1**answer

54 views

### Multiple conditional color formatting on a cell using IF… IF… ELSE

I've got three columns of Names, gender, DoB. Gender column as either "M" or "F" keyed in. DoB column has the date of birth mentioned as dd-MMM
Color formatting of DoB column needs to fulfill the ...

**1**

vote

**1**answer

29 views

### Selective conditional formatting when midnight is time in the cell

I have created a sheet where the first column is an hourly timeline starting with a user entered time and date. The user inputs the time and date in cell F4. Subsequently the timeline starts in cell ...

**1**

vote

**1**answer

94 views

### Color-based text in Excel cell

Looked through available options, but failed to find the one in a format I would understand steps.
Working with Excel. Need to have cell changing color based on specific wordS (not one). For example ...

**1**

vote

**1**answer

58 views

### Copy Conditional Formatting 3-Color Scheme to another tab

I have one sheet, Tab 1, with a 38x12 grid of values ranging from -30 to +30. I applied the traditional 3-color scheme conditional formatting to the data, which shows all shades of the spectrum ...

**1**

vote

**1**answer

22 views

### Conditional Formatting in Excel via a different worksheet

I've been trying to figure out how to make a cell bold and color red based on conditions entirely in a different worksheet. For example, I'd like Sheet1!A1 to be bold and red when Sheet2!A1 = ...

**1**

vote

**1**answer

30 views

### How to get Excel conditional formating to recognize boolean operations

I have constructed a spreadsheet to color code incoming scientific data based on different levels of criteria.
My problem is with data coming in as 'less than'.
For example, if the data shows ...

**1**

vote

**1**answer

297 views

### Align rows from different columns (which contain some cells that have identical values) using simple formula in Excel

I have 2 tables in Excel and I am trying (via Excel formula) to match/align some rows (ones that contain identical letters for the sake of the example included below). Btw, I don't mind aligning Table ...

**1**

vote

**1**answer

89 views

### Dealing with absolute references in a conditional formatting macro

Say I have the following simple data in Excel:
A B C D E F G
2 1 3 2 5 4
2 4 2 1 3 2
5 2 1 3 2 4
I want to set up ...

**1**

vote

**1**answer

597 views

### Excel VBA - Conditionally format a cell using 2-color scale based on 2 values (max/min) on other cells

I'm trying to write VBA codes to conditionally format (2-color scale) cell A1 based on its value that between is >= cell A2 and <= cell A3. I'm using cells A2 and A3 so I can change the specific ...

**1**

vote

**0**answers

54 views

### How do I use an IF-THEN or Condition Statement for Excel 2013?

What would the condition statement be if I wanted all my sold items to go red in column F, but leave the ones un-shaded that have the word "Received" also in column F? The Headings of my Excel sheet ...

**1**

vote

**1**answer

374 views

### How to use Conditional Formatting to change text color to match conditional fill color

I have used the Conditional Formatting to change the Cell fill color based on the percentage number. However, I would like to hide the text so I just have a bunch of colored squares with no value ...

**1**

vote

**1**answer

627 views

### Alternative to cell highlighting using conditional formatting in Excel without causing freeze/crash

In column A, I have a value and I want to highlight if it doesn't match the same value in column B.
I'm using the formula below in conditional formatting which works great.
...

**1**

vote

**1**answer

81 views

### Get conditional formatting to analyze rows separately

I have a calendar and I am trying to fill the background of the cells based on dates on another sheet.
I have gotten it to work by entering the dates in a columns, naming the range (lets says ...

**1**

vote

**1**answer

301 views

### Advanced data consolidation in Excel

I need to Combine/Consolidate Data dynamically between over 20 separate Excel workbooks. The Column names and their relative position at the top row are the same. The positioning of each word under ...

**1**

vote

**1**answer

869 views

### How do I use Conditional Formatting based on due dates in Excel 2013?

I am trying to format cells in Excel 2013. I want the cells to get colored as green, yellow, and red based on how close they are with the target date (January 13, 2015 in this case).
I am unable to ...