Spreadsheet feature that allows automatically adding color, text styles, etc. to certain cells or ranges of cells based on the data workbook

learn more… | top users | synonyms

0
votes
3answers
34 views

Excel 2013 - combining conditional formatting

I'm not very proficient when it comes to Excel formulas, so a few weeks ago I posted a question & got a great answer. Since then, I realized there's one additional thing that would make this even ...
0
votes
1answer
21 views

How do I insert thousands-separators without affecting significant figures in Excel?

I need to figure out how to add thousands separators to large spreadsheets without affecting the amount of significant figures or the dates that are also in the tables. I can't figure out how to use ...
0
votes
0answers
26 views

Excel - Can I use a date range to format a cell

I have a calendar and a table of events on a worksheet. The table of events include a Start and End date as well as Status columns. I would like to highlight the dates on the calendar where the ...
0
votes
1answer
31 views

Microsoft Excel TIME related Conditional Formatting

I'm maintaining an attendance table in the following format. 01 Wed IN | 01 Wed OUT ==========|=========== 08:27 | 17:16 08:36 | 14:31 08:38 | 17:07 08:32 | 17:05 08:47 | 17:05 ...
0
votes
0answers
14 views

Excel Automatically Fill Cells In Time Range

I am trying to create a calendar that will fill cells in the graph to reflect the times listed out in Columns D and F. In essence, my hope is that I can enter the start time, enter the end time, and ...
0
votes
0answers
15 views

Extend 3-color conditional formatting from one column to adjacent column

I want to format my cells in a way where the colors are displayed according the the color-rule as in column 1, but the values that you see within the colored area are the ones of column 2. Column 1 ...
0
votes
1answer
27 views

Applying conditional formatting to individual rows

I'm trying to apply conditional formatting to a few hundred rows of data, but I want to keep them separate. Meaning, if I want to coloring cells based on their proximity to the average value, I want ...
0
votes
1answer
30 views

Conditional formatting in Excel combining 2 rules?

I want to format my dataset (22x12 values) with the 3 color rule, but based on the values of another dataset so that the color can be used as additional information. Here my example. I want to ...
1
vote
1answer
23 views

Cannot use Conditional Formatting in Workbook

The problem is simple enough to state. When I select a range of cells (as numeric values or indeed as values calculated from a formula), I cannot conditionally format them. What I want to do is to ...
3
votes
0answers
45 views

Highlight differences between two Excel spreadsheets

Data from Spreadsheet A has multiple columns but I need to compare only: Column A - order # Column C - count Column D - date Spreadsheet B also has many columns, but I need to compare: Column A - ...
-1
votes
2answers
51 views

Excel 2013 - combine conditional formatting

Excel 2013, Windows 7 Pro. I have a spreadsheet with some Conditional formatting, but I need multiple rules & I don't know how to make them work correctly together. 1) First, I want one specific ...
0
votes
1answer
24 views

Excel 2010 Conditional Formatting Cell color based on a group of text cells

Hi I need help with changing the color of a cell based on the Text values in the cells below it. So say B1 is the cell i want to change. B2-B7 has text values 'Yes', 'No', 'In Progress' I want to ...
0
votes
0answers
8 views

Is there an easy way to manage a large number of conditional formatting rules?

Using Excel 2010, I've created a very large number of conditional formatting rules. You can see how small the thumb is - there are a lot of them. Unfortunately, the conditional rules manager dialog ...
0
votes
1answer
800 views

If Function is not working in Excel

I had made a sheet to calculate factory workers timing and payment against working and over time. First I made it in Excel 2013 and then I changed my Windows from 10 to 7 and also changed the ...
1
vote
3answers
2k views

Color scale for text values in Excel

I would like to apply color scale on text values. But unfortunately, it works only on numbers! I’m doing this to easily identify the repeated values sorted by other column. This image explains the ...
0
votes
0answers
21 views

Getting Excel to Conditionally Copy Data to Another Sheet

I have a spread sheet that will have new data entries on each row. I need to get excel to automatically check for a specific column's value, and if that value is a 1, it needs to go to the sheet with ...
0
votes
2answers
31 views

Apply Custom Number Formatting to Error values

I'm trying to apply a custom number format to cells in Excel 2007 that return an error value. I understand that I can apply custom number formatting to number/text values in the form POSITIVE;...
6
votes
1answer
2k views

Conditional formatting to highlight the whole row

I would like to highlight the whole row 5 if J5="T". I used to do it with the old Excel, the 2010 conditional formatting ignores it. So my rule is like this and it does not work. I used the formula $...
2
votes
2answers
142 views

Conditional formatting on the first x number of rows, regardless of filter or sort, in Excel

I'm trying to find a way to easily identify the first ten rows in a table column, no matter how it's been sorted/filtered. Is there a way to use conditional formatting to highlight these cells? ...
0
votes
0answers
37 views

White space between columns in Excel

There are white spaces between columns in excel when I have conditionally formatted them to shade depending on row. How can I fix this?
0
votes
0answers
22 views

Conditional formatting of “difference lines” in a 2 series chart

I have 4 columns of data: 1st column is the name of the Route 2nd column is Time1 in decimal hours 3rd column is Time2 in decimal hours 4th column is TimeDifference in decimal hours (or decimal ...
13
votes
3answers
86k views

Color Cell Based On Text Value

An Excel column contains a text value representing the category of that row. Is there a way to format all cells having a distinct value a unique color without manually creating a conditional format ...
0
votes
0answers
25 views

Extracting a Sublist from Master List

How do I write a formula to find the exact matched of the subsets and extract it from the master? Basically what I have is a master data spreadsheet of 275,000 rows of data. I then have a queried ...
0
votes
1answer
55 views

Formula or VBA for cell formatting using value based on a cell but formatting from an other cell

I have a fixed set of values, (0%,20%,40%,60%,80% and 100%) in column E. If I fill a cell in column E with any of the above values, the cell G should pick formatting from another cell. For example, ...
0
votes
2answers
24 views

Custom formula for databars in Excel

How would one go about using a custom formula to determine the format conditions for databars? Meaning, in Excel under "Conditional Formatting" there's a format called "Data Bars". However, you ...
0
votes
2answers
2k views

How to Change Conditional Formatting of a Cell Based on a Change in the Cell Value

I am desperately looking for a way that allows me to conditionally format a cell depending on whether its value has increased, decreased or stayed the same. However, I don't want to compare its ...
0
votes
1answer
20 views

How do I represent 1 + “” in conditional formatting?

I have a formula that spits out 1 and "" in the same cell. (its an &) anyway it stopped the conditional formatting from recognizing the cell's value as 1. What value can I use to make the ...
1
vote
1answer
631 views

Recolour a single occurrence of a recurring appointment in Outlook 2010

Brief: Recolour a single occurrence of a recurring appointment. I have the following recurring appointment: Subject: Maths 104 Date: N/A (series) Time: Thursday 12pm Recurring: Weekly (4th March to ...
0
votes
1answer
63 views

Outlook: Shared Calendar conditional formatting

Situation: My work group has a shared conference call dial-in number. To avoid double booking the dial-in number, we have to reserve time in a shared calendar. All users have read/write permissions, ...
0
votes
1answer
19 views

Excel: conditional formatting with with complex function AND

I have a sheet that looks like this: So I have a list of documents to create, and I mark "1" on the column with the month in which I have created them. Now I've been asked to put "1" also as a ...
1
vote
3answers
44 views

Conditionally format entire row based on a cell value [duplicate]

I know this has been asked before, but I must be missing something. I want to put a border above all rows that contain "Monday". The formula is =$B$3="*Monday*" I thought it might be because ...
0
votes
0answers
33 views

Excel 2010 Conditional Formatting issue

I'm experiencing a problem with conditional formatting in Excel 2010. I want any value other than 1 to be shown in red. I am working with multiple tabs, with one main tab. The entries in the other ...
1
vote
1answer
51 views

How to highlight 2017 in Excel

I need cells in Excel to be highlighted if they contain 2017 in the date. For instance there is a column that has just dates. Some dates are for 2017. I need to input those dates at a later time. The ...
1
vote
0answers
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 ...
7
votes
3answers
17k views

Excel 2007: Conditional formatting so that each row shows low values yellow, high values red

I have a spreadsheet with approx 300 rows. Each row has about 15 columns, and each cell contains a numeric value. Each row corresponds to a product. I want to get Excel, for each product, to ...
0
votes
1answer
29 views

Excel - Format cell showing always the first digit

So my question is simple, but I have trouble solving it. I want the cell to show always the first digit, no matter how long the number is - for example if I type 0123 - it displays 0123, and if ...
0
votes
1answer
48 views

Excel formula to show differences in columns

In Excel, I want to highlight the difference between 2 columns so that I can see if the person's money has increased or decreased by more than £500 since last month. I don't want to add a 3rd column ...
2
votes
1answer
115 views

How to search Excel conditional formatting formula with specific text

Sorry I did try to search but could not find a question similar to what I want. My Question: Is there any easy way I could search all conditional formatting that has formula with specific text? I ...
0
votes
0answers
27 views

Using Excel to flag non contiguous data

I need a way to flag gaps in a list of numerical data. Like using conditional formatting to flag a series like 1,2,3,5,6,7. The cells containing 3 and 5 would be highlighted showing a gap.
3
votes
1answer
3k views

Excel conditional formatting to highlight entire row if one date is not equal to another date in that row

I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a date ...
1
vote
0answers
4k views

Conditional formatting, greater than a year in Excel

I am working on a spreadsheet that logs the dates parts were sent out and would like to apply conditional formatting to the dates. I would like if over 3 years ago, if over 2 years ago, if over 1, ...
0
votes
1answer
212 views

Displaying data in Excel graph only up to current date?

I have an Excel chart that displays 5 sets of data in a single scatter plot, where the X axis is the date of occurrence. In my table, I have both actual values from previous dates and projected values ...
1
vote
1answer
134 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 ...
0
votes
1answer
453 views

How to use conditional formatting to highlight specific days of the week AND time periods?

This answer regarding formatting on date time information Excel 2010 Conditional Formatting - TIME is a very, very technical answer that, in truth, I don't really understand! Hey-ho, I can deal with ...
1
vote
1answer
40 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 | ...
0
votes
0answers
24 views

Change text color and underline output of Excel [duplicate]

I'm wanting to do something I thought to be simple but can't seem to get it working. I want an IF statement that, once evaluated, the result output is underlined and changed to a color (e.g., red). ...
4
votes
0answers
187 views

Conditional formatting for meetings outside normal working hours in Outlook

I'm trying to get meetings that start before 10:00 AM highlighted in red. I've tried to use the Conditional Formatting feature; in the advanced tab I selected the "Start" field and "on or before" ...
0
votes
1answer
331 views

How do you use conditional formatting in Excel to format based on previous cell information?

I have a document that is created to monitor complaince. I would like to have the following rules: Highlight the cell if it meets a goal - I've figured this out and the formatting works. Highlight ...
0
votes
1answer
53 views

How to format entire row when any cell of the row contains any value?

I want when there is any value (whether any alphabetic or numeric value) in any of the cell into the row from a1 to p1 then the entire row (from a1 to p1) should be formatted. For example there is ...
0
votes
3answers
66 views

Highlight birthday in a referenced cell

in Excel 2003 in worksheet1, I have a conditional formatting that highlights a cell when today is the birthday in cell A1 date of Birth in cell B1 age with the formula: =DATEDIF($A1,TODAY(),"Y") &...