**0**

votes

**1**answer

13 views

### How to use conditional formatting to search a specific value in a range in ms excel?

I have values in the range K5:K333. I want the value in cell S5 be searched in the range and the corresponding cells of the range being formatted.
I am using conditional formatting's "use a formula ...

**2**

votes

**1**answer

21 views

### Highlight rows that don't match other sheet

I'm not sure if this is possible, but I have two spreadsheets that I need to compare in a few different ways.
Here is the scenario:
**Sheet 1**
Column O=Claim Number;
Column P=Reserve Indemnity; ...

**0**

votes

**1**answer

17 views

### Highlight row if ID is found on other sheet

I have one Excel file that contains 2 worksheets.
Worksheet 1 columns:
computernames Username E-Mail
comp1 username mail@mail.de
comp2 username2 mail2@mail.de
Worksheet 2 columns:
...

**0**

votes

**0**answers

11 views

### Outlook “conditional formatting” for meetings without other attendees

I'm trying to get meetings with other attendees (other than myself) to show up in a special color. My "own" meetings (without other attendees) are mostly just reminders, which I can easily move, but ...

**2**

votes

**2**answers

33 views

### Highlight duplicates only if the header is the same

I'm attempting to use Conditional Formatting to highlight a duplicate entry if and only if the Header to both columns are the same.
In my example below, this is a season long NFL contest of picking ...

**0**

votes

**0**answers

17 views

### Outlook Query to highlight messages that mention me?

In essence, I want to do some conditional formatting on messages that mention me. Below are 3 sample Messages (Bodies). The first two should be purple, the last one should not be purple because I ...

**1**

vote

**1**answer

43 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 ...

**2**

votes

**2**answers

32 views

### Excel conditional formatting rows to highlight weeks in different colours

I am trying to automatically format the rows of my worksheet based on the date in the A column.
I am using the following to highlight the weekends.
=WEEKDAY($A6,2)<5
This works however I also ...

**0**

votes

**3**answers

30 views

### Conditional formatting with multiple conditions

I have to set a simple formatting in excel: colour cells if the value is = to another cell.
The question is that I would like to colour the cells if the value equal to A1 or B1 or B3
Is it possible ...

**0**

votes

**1**answer

19 views

### Prevent Outlook calendar conditional formating happening on iCal feed

I've got two calendars in Outlook 2010:
My own calendar (which comes from the company exchange server)
My personal calendar (which comes from Google in the form of an iCal feed)
If I apply ...

**1**

vote

**1**answer

22 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 ...

**0**

votes

**0**answers

15 views

### Microsoft Excel 2013 - Auto-generating a page with parent formating

I have a multi-line activity log which is created using merged cells and colored borders, and often times the activity log follows on to a new, un-formatted page.
Is there a way to have excel create ...

**0**

votes

**1**answer

31 views

### How do I get the cells with no dates to have no color until the date is entered? All of the unused cells are red

=DATEDIF(F2,TODAY(),"m")<=47 THE CELL TURNS NO COLOR
=DATEDIF(F2,TODAY(),"m")>57 THE CELL TURNS RED
=DATEDIF(F2,TODAY(),"m")>54 THE CELL TURNS PINK WITH RED WRITING
...

**0**

votes

**2**answers

49 views

### In Mac Excel 2011, how to format cell as percentage or currency based on content of another cell?

As far as I can tell, the Conditional Formatting feature doesn't support percentages. You can format styles (color, font, etc.), but not the actual content presentation itself.
I have two columns, ...

**0**

votes

**1**answer

36 views

### Excel formula related to conditional formatting

Column A has 10 numbers expressed as percentages and is conditionally formatted to highlight the top 40%.
I want column B to show a "1" next to the corresponding highlighted top 40% of numbers in ...

**0**

votes

**0**answers

30 views

### Excel 2007 Conditional Formatting On Formula Not Updating When Cell Updates

I have set the following conditional formatting rules:
=$B97=1 Set Format (Custom) ">" @ On cell =$D97
=$B97=2 Set Format (Custom) "> >" @ On cell =$D97
=$B97=3 ...

**0**

votes

**2**answers

51 views

### IF statement with multiple criteria and multiple possible results

I have a spreadsheet and I need a formula to give me one of three possible results (good, neutral, bad) based on data from two cells. MTD and YTD on budget would be good, MTD on budget & YTD below ...

**1**

vote

**1**answer

16 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 = ...

**0**

votes

**1**answer

35 views

### How do I highlight the max values across every column in a pivot table?

Looking for a way to use conditional formatting to highlight the max value in every column of a pivot table.

**0**

votes

**2**answers

46 views

### Is it possible to have an Excel formula dependent on value input?

Is it possible to have Cell G24 recognize the number in D24, and do its math depending on the size of the number, using the in Cells B37 through B42?
I have a basic spreadsheet for cataloging sales ...

**0**

votes

**1**answer

45 views

### How do I superimpose a conditional formated heatmap based on one set of values over a different set of values in Excel 2013

I would like one cell to be formatted with a gradient color based on the value in another cell. For example, I would like cells A1 and A2 to be highlighted based on the values in B1 and B2. If I ...

**1**

vote

**1**answer

34 views

### Lock color scale (convert to fixed)

I have used conditional formatting to apply a color scale to a range of values. Now I would like to permanently freeze those colors. I have poked around a bit, and can't find event the beginning of ...

**0**

votes

**0**answers

16 views

### Conditional formatting in Excel 2010 - Highlight a whole row in which a cell value falls between a specific day range

I need the whole row highlighted in yellow if the value entered in a cell (in Column C) falls between the 6th and 19th of any month or year, or in blue if it's between the 20th and the 5th.
Thank you ...

**0**

votes

**0**answers

19 views

### Excel - Conditional formatting retention through data validation in another sheet

I have applied conditional formatting in an Excel sheet (Sheet2) to change the font color in column A if the result in the adjacent cell in column B is "No." I then used this conditionally formatted ...

**1**

vote

**1**answer

36 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

28 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 ...

**0**

votes

**2**answers

36 views

### Conditional formatting to mark rows depending on contents

I have an excel sheet that for the forseeable future will remain as a Work In Progress regarding a project. To easily be able to keep track of rows that need some work I would like to create a macro ...

**2**

votes

**2**answers

49 views

### A Conditional Format to change the background color but keep the Date format

I have and OpenOffice Calc document that has a "table" with Text, Numeric and Date columns. I have a conditional format making every odd row have a different background color so it will be easier to ...

**1**

vote

**1**answer

41 views

### Conditional formatting based on specific cells

Is it possible to set conditional formatting based on a value written in a specific cell?
I would like to colour the rows of saturday and sunday and not colour the working days.
The condition is ...

**1**

vote

**1**answer

74 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

36 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 ...

**0**

votes

**3**answers

55 views

### Adding a date to a formula in excel [closed]

=$M2="COMPLETED"
I am using this formula to shade a row when COMPLETED is written in column M, but I would prefer the 'date' or 'COMPLETED and the date' but can't seem to work out how to do this.
...

**-1**

votes

**1**answer

81 views

### Formatting - conditional - vlookup- values from one cell to another different worksheets based on value

I would like to be able to enter a part# in column L of sheet 2 and a formula would look through column A of sheet 1 for a match, and then return their price from column F of sheet 1 into column K of ...

**1**

vote

**1**answer

304 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 ...

**0**

votes

**1**answer

36 views

### EXCEL: Icon Conditional Formatting Based on Range of Values

I am creating a spreadsheet for work and I need to format cells such that I get a green check mark when the value in the cell is between 100 and 101, yellow ! if it is between 97 and 100, and red X if ...

**1**

vote

**1**answer

51 views

### Excel: Conditional formatting not filling in cells if adjacent cell is filled

I am trying to fill a pair of cells in if both are blank. Which works unless the cell next to the pair is filled in. How do I go about resolving this issue?
Formula:
=AND(ISBLANK(F2),ISBLANK(G2))
...

**0**

votes

**1**answer

48 views

### Combining the ISBLANK and Date function

I have been searching through forums and can not figure out how to succesfully combine the two functions ISBLANK and a date function.
What I need to do is use this formula in google sheets for ...

**0**

votes

**1**answer

182 views

### how to highlight the cell with the max value

given a range of non adjacent columns (not sure if it matters if they're adjacent) i.e
F1:F100,J1:J100,N1:N100
for each row i'd like to highlight the cell with the maximum value.
i tried ...

**0**

votes

**0**answers

33 views

### How do I apply conditional formatting to many workbooks?

I have 120 similar excel workbooks. They each have one sheet containing a small customer databases.
I want to apply conditional formatting to all these workbooks. I can do it in one workbook. Is ...

**1**

vote

**0**answers

48 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

115 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 ...

**0**

votes

**0**answers

100 views

### Excel: Conditional formatting for column merge

I'm looking to create a timetable that is formed by combining material from several worksheets. It does not seem to be possible to automatically consolidate text from several worksheets, but it is, of ...

**0**

votes

**1**answer

69 views

### Finding Clustered/Consecutive Values in Excel

I am trying to find values in an Excel spread sheet where numbers greater than 0 will be highlighted. However, those highlighted must be clustered, consecutive numbers which should be (at least) three ...

**0**

votes

**0**answers

24 views

### Conditionally change colors of events in calendar on mac?

Is it possible to conditionally change colors of particular events in calendar for mac ? the same way week cal on iOS works? Maybe with applescript?
I havent found any apps for mac that can do that.
...

**1**

vote

**1**answer

1k views

### How do i right align an icon set arrow under conditional formatting so that both number and arrow are on right side of cell neatly together?

Cell displays a conditional format arrow Icon set which is on far left side of cell. The number in that cell is right aligned and I want to bring the arrow directly next to the number. I want the ...

**2**

votes

**1**answer

30 views

### Excell 2007 conditional formatting

I have created an excel spreadsheet where in each cell there is a formula which gives a value with two decimals. I need to use the conditional formatting to highlight the cells in which the second ...

**0**

votes

**3**answers

76 views

### How to highlight where a number in another cell falls in a column? Bracket it with the next highest and next lowest?

This is probably an easy fix. I have one cell (Cell B8) with say the number 2000 in it. I have another column of 6 numbers (Cell A1 to A6) (Say 4000, 3050, 2100,2100, 1150, 200) that will change with ...

**1**

vote

**1**answer

532 views

### Alternate Row Colors of Duplicate Data in Excel

I am working with a dataset in Excel that contains duplicate values and non-duplicate values that are numbers. I would like each duplicate value group to have alternating shades via Conditional ...

**3**

votes

**1**answer

118 views

### How to color rows based on two cell values in Open/Libre Office?

I am trying to apply conditional formatting to an entire row based on two cell values. The style is to be applied only if both cells have a particular value. I tried applying formula of the form:
...

**0**

votes

**1**answer

56 views

### In MS Excel how do I set the number of decimal places dynamically?

I have a table where I am reporting a range of correlation coefficients which range from -1.0 to +1.0. I want to format them such that if they are plus or minus one or zero, then they are formatted ...