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

2
votes
1answer
65 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; ...
2
votes
1answer
37 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 ...
2
votes
1answer
356 views

How to apply conditional formatting only to cells that contain a subtotal formula

I have a list of values, I have to alternate color of each row (that works fine). In that list I also have subtotals, calculated using the SUBTOTAL function. How would I be able to give just the ...
2
votes
1answer
31 views

How to show a value of a Cell as it's displayed

I have a cell A2 that shows the value 001. I want to concatenate that value of 001 to a string to show REQ-001. The cell that I want to show this string I have =CONCATENATE("REQ-",A3). But the ...
2
votes
1answer
114 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 ...
2
votes
1answer
172 views

Excel conditional formatting when part of validation list

I'm trying to use conditional formatting on a cell that is populated via a validation list. It will not format. I try the exact same formatting on another cell which is not populated from a drop ...
4
votes
0answers
2k views

Excel 2010 crashes: Excel.exe 0xc0000005 when trying to highlight from pivot table

One of our users uses pivot tables a lot. She often called me about Excel crashing from time to time without being able to reproduce the problem. Today we have found a way to reproduce the crash every ...
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" ...
3
votes
0answers
44 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
vote
0answers
41 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
0answers
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
0answers
139 views

Creating a list from another list's value

How can I populate a cell with a list as a result of a condition from another dropdown list? I have a dropdown list, when I select a value from it I will need to populate the cell beside it with ...
1
vote
0answers
62 views

Formatting of entire column based on the grand total using color scale?

This might be answered somewhere else, but I haven't been able to find a solution to this. The question is how to use color scale for entire column just based on grand total. I have attached the ...
1
vote
0answers
34 views

Excel for Mac 2011 - Conditional Format - Look inside formula for sheet reference

I would like to use conditional formatting to locate all cells on a large sheet (Sheet 1) that have a reference to another sheet (Sheet 2) within a formula in a cell on Sheet 1. I was hoping I could ...
1
vote
0answers
240 views

Conditional Formatting a date/time comparison

The function I'm working on specifically compares & colors a daily recurring time range set in 2 different cells. A specific date in the target cells (produced by a formula) compare to that daily ...
1
vote
0answers
77 views

Conditionally generate Excel sheet

I currently have an excel sheet that is used to record daily a bunch of parameters. Currently, I have a folder for each year, containing a folder for each month, inside of which I have an excel file ...
1
vote
0answers
351 views

Excel 2011 Conditional Formatting: compatibility issues

I would like to create a workbook in Excel 2011 for Mac that is fully usable in Excel 2003 (on Windows XP, Compatibility Pack installed). The purpose is a semi-automatic calendar, where one enters ...
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
0answers
12 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
18 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
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
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
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
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 ...
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
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 ...
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.
0
votes
0answers
73 views

Conditionally apply formatting (table style options) to word-table last row

In word 2016 I have a document template with a predefined table-style. When I apply this table style I can choose to e.g. apply 'total row' formatting. I would like to apply total row formatting via ...
0
votes
0answers
36 views

Excel Conditional Formatting disappears unless smaller dataset in filter

Conditional Formatting on a Power Pivot (Excel 2016 32-bit) using a Color bar is working nicely when results are page filtered to a smaller subset. But when nothing is filtered, the CF disappears, so ...
0
votes
0answers
30 views

Conditional formatting from a clock on Excel 2010

I was wondering if anyone can help me with my spreadsheet. I have set up a macro in cell L1 to run a clock the programming is as follows: Dim running As Boolean Sub clock() running = Not (running)...
0
votes
0answers
52 views

Conditional formatting to highlight differences between 2 pivot tables in Excel

I have an Excel issue I hope somebody may be able to help me with please? I have 2 pivot tables that both contain the following fields: 'Provider ID' in the Rows area, 'Month' in the Columns area ...
0
votes
0answers
27 views

EXCEL: How can I use a custom function created in VB as formula for conditional formatting?

I created a VB script to validate a personal document from my country (just like the Social Security number in USA). It is BOOLEAN, receives the number as param and returns only TRUE or FALSE if it's ...
0
votes
0answers
120 views

Conditional formatting of pivot table cells based on value of a separate field

I have a pivot table which has, for the purpose of this question, "document-ID" as a row label, "person" as a column label and "date signed" as value field. Is it possible to give each cell containing ...
0
votes
0answers
20 views

Condtional formatting

I have a question on how do you write a formula in a conditional formating if it sees the text funded in colume h I want to highlight column a the loan number when it sees the world funded only for ...
0
votes
0answers
25 views

data bars conditional formatting in Excel

I need to format cells in a column with data bars of two different colors, depending on cell values in previous column. For example: if the value in the cell on the left is greater than zero, then ...
0
votes
0answers
110 views

Conditional format a single letter without other cells containing the same letter

I need to conditional format my spreadsheet so that all the Nos ( N ) and all the Yes' ( Y ) are formatted without other cells containing the letter n or y also being highlighted. I would like to ...
0
votes
0answers
11 views

Conditional formatting icon sets of one row applied to other rows, icon sets

I have a question on how to apply conditional formatting icon sets of one row to other rows without using format painter? The issue is that I have over 100k rows. For example, the data is compared ...
0
votes
0answers
38 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 ...
0
votes
0answers
19 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
0answers
82 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
0answers
25 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
0answers
34 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 ...
0
votes
0answers
52 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 ...
0
votes
0answers
159 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
0answers
43 views

Formatting of dates in cell using Excel to show result as numbers

I am working with calculating the difference in years, months and days between 2 dates. My results are showing as eg. 32 years, 9 months, 3 days. How do I format the cell to show a result 32 9 3? I ...
0
votes
0answers
36 views

Conditional Formatting duplication in Excel 2013

On looking for solutions, some seem to have found the answer ... which unfortunately, does not seem to work for me in Excel 2013 (apparently the issue existed already in 2007... but did not get solved ...
0
votes
0answers
363 views

Update conditional formatting cell references when conditional formatting is applied to new cell

I am applying conditional formatting to cells on my spreadsheet, using the following formula in cell C6: =INDEX('All Time'!$F$2:$F$550,MATCH(INDEX('All Time'!**$A$7**:$A$550,MATCH("*",'All Time'!$A$7:...
0
votes
0answers
2k views

How to use a color coded drop down in Excel across multiple sheets?

I have seen a few examples on how to create a color coded drop down in an excel spreadsheet. An example of what to do can be seen here. http://stackoverflow.com/questions/12643522/excel-2007-drop-...
0
votes
0answers
40 views

How to use Color Bar for String Values in Excel 2010

I like to color the backgrounds of the cells which has similar values. There are huge no. of such values so it is not possible to create condition/rule for each. I am looking for a shortcut. Like this ...