Tagged Questions
3
votes
1answer
26 views
Excel conditional formatting fragmentation
Often, I create a sheet with conditional formatting, and set the cell ranges so that the conditional formatting rules are only applied once to a range of cells, e.g.
Make $A$1:$A$30 red and
Make ...
1
vote
1answer
29 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
1answer
44 views
Conditional Formatting - Highlight An Entire Row by Comparing Two Cells of a Column
I've dug through the questions on this site and they address both problems I have, but separately. I've been trying to combine the solutions for a couple hours with no success.
Basically, I would ...
1
vote
1answer
50 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
2answers
35 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 ...
0
votes
3answers
204 views
Is it possible to save conditional formatting rules for reuse in a new workbook?
I want to make some rules that I can haves saved that I can easily apply to new workbooks as needed. It's a pain doing it how I currently do where I'm always having to go back through and recreate ...
-2
votes
1answer
49 views
Conditional date formatting
The following needs to happen:
Enter a goal date in cell C1 and enter actual completion date in D1 when project complete
D1 will remain blank until project is complete.
If D1 is blank:
STATE 1 -- ...
0
votes
1answer
50 views
Excel cell formatting to fill color
I'm doing some excel formatting, with below formula being used:
=IF(OR(ISBLANK(E23),ISBLANK(E24),ISBLANK(E25)),"Section Incomplete","Section Complete")
Basically, When the cells E23, E24 and E25 ...
4
votes
1answer
126 views
How to conditionally create a hyperlink based on value of a cell
ColA Col B ColC
Project A A.pdf A.pdf
Project B No Link
I have a list of project records. One column (e.g., B) ...
2
votes
3answers
104 views
How to format a date field based on whether the date has passed?
I am trying to create an Excel spreadsheet where, when I input a date:
if that date is within 30 days it will go yellow,
if the date has already gone then it goes red, and
if the date is more than ...
0
votes
1answer
70 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 ...
2
votes
1answer
64 views
how can I use conditional formatting in excel to search for a list of values
I have two columns of data, one which contains a large number of values (column a), while the other contains a smaller amount of values(column e). I was wondering if anyone knew how to search for and ...
3
votes
1answer
47 views
Formatting Entire Row with Multiple Rules
I would like to change the formatting (specifically text color) for an entire row based on which selection is chosen from a drop down list in Column C. Example:
If C2 equals 'XX'(one of the ...
0
votes
3answers
358 views
EXCEL: How to conditional format a thick bottom border to an entire row based on one column value? [duplicate]
Possible Duplicate:
Excel conditional formatting to highlight entire row if one date is not equal to another date in that row
I have the following rows...
1 AA 12 13 4 7
1 A ...
1
vote
1answer
167 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 ...
0
votes
0answers
104 views
Colour table cells in Microsoft Word after mail merge
I have an Excel spreadsheet of student data. For each of 30 topics, students are traffic lighted R, A or G (for red, amber, green) in the spreadsheet. I am mail merging individual result print-outs in ...
2
votes
4answers
167 views
Is it possible to have a conditional formatting cell “visually cycle” through all the formats that evaluated true?
Like the title says, "In Excel, when a cell has multiple conditional formatting rules that evaluate true, is it possible to have the cell "visually cycle" through all the formats that evaluated true? ...
1
vote
0answers
42 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
3answers
142 views
How to create a conditional format in excel 2007 from another cell
I have a sheet with 4 fields spanning A3:D3
in D3 I have a conditional format that turns the cell yellow if it equals the word "no contact"
How can I get Cells A3:C3 to also turn yellow if this is ...
1
vote
0answers
139 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
votes
1answer
243 views
Set an Excel cell's color based on multiple other cells' colors
I have an Excel 2007 spreadsheet for a list of products and a bunch of factors to rate each one on, and I'm using Conditional Formatting to set the color of the cells in the individual attribute ...
1
vote
1answer
571 views
Excel 2007 - Conditional Formatting: Compare 3 columns with text - find unique values
I have a spreadsheet with three columns, each column listing the folder names found on a server.
Server1 | Server2 | Server3
--------|---------|---------
A | | A
...
2
votes
1answer
116 views
Excel IF Condition
In Excel, how would I perform the following using the IF condition?
If cell is empty then set the background color to red.
If cell has a value then set the background color to green.
2
votes
2answers
692 views
Vertical Histogram in Excel with Conditional Formatting
I'm able to do data bar conditional formatting in Excel 2010, but I can't figure out how to switch the bar axis to make it vertical. Is there any way around this? Can I simulate a vertical histogram ...
0
votes
2answers
395 views
Setting background colour of cells based on their string length
Suppose I have this column of data
Canada
Chile
China
...
How do I set the background colour of each cell if the length of the string in it is greater than say 5? ('Canada' cell would be ...
1
vote
1answer
120 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 ...
2
votes
1answer
2k views
Formatting a column based on another columns cell TEXT (not value) in Excel [duplicate]
Possible Duplicate:
Excel 2010 conditional formatting: selectively highlighting duplicates
I have dates that are running off a formula in that column based on information it's collecting ...
2
votes
2answers
4k views
How to change row color based on a single cell's value? [duplicate]
Possible Duplicate:
Conditional formatting of TRUE / FALSE values in an Excel 2010 range
I have a spreadsheet where I have cell within a row that will contain specific text via data ...
3
votes
2answers
1k views
Excel: conditionally format a cell using the format of another, content-matching cell
I have an Excel spreadsheet where I’d like to be able to create a “key” of formatted cells with unique values, and then in another sheet format cells using the key formatting.
So for example, my key ...
2
votes
1answer
245 views
Excel conditionally format a row based on a cell
I have a table something like this:
text1A | text2A | value1A | text3A | value2A
text1B | text2B | value1B | text3B | value2B
text1C | text2C | value1C | text3C | value2C
If the value in column 3 ...
2
votes
1answer
222 views
Transferring Conditional Formatting (without the cell value) in Excel
If I have 3 layers of conditional formatting in a cell (B2) is there a way of transferring the format of cell (B2) to another cell (A2) without copying across the value in the original cell (B2).
...
0
votes
0answers
18 views
How to apply Conditional Formatting to a row of data if a certain cell is blank [duplicate]
Possible Duplicate:
Conditional formatting to highlight the whole row
Here's the problem I am facing:
I want to highlight A1:M1 if L1 is blank, A2:M2 if L2 is blank, A3:M3 if L3 is blank, ...
3
votes
1answer
878 views
Excel 2010 conditional formatting: selectively highlighting duplicates
I'm using Excel 2010 and would like to know if there's any way I can choose conditional formatting to highlight only instances of duplicates when it's found in ALL the columns I chose?
For instance, ...
0
votes
0answers
285 views
How do I use conditional formatting in Open Office Calc to use an image for the background instead of a color?
Ok so we have a spreadsheet that we are trying to reproduce in Open Office Calc that was created in Microsoft Excel. The feature that we are trying to emulate is using an image instead of a background ...
0
votes
0answers
953 views
Excel conditional formatting, greater than a year
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, ...
2
votes
2answers
557 views
Conditional formatting issues in Excel
I seem to be having a problem with conditional formatting in Excel 2010. I have a set of date points, percentages between 1 and 100. I applied three rules in the following order,
if greater than ...
2
votes
1answer
550 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
1answer
459 views
How to change cell color based on today's date in Excel 2010
How do I Change cell color in Excel 2010 for upcoming or past dates based on 90 days from today. I would be great if I could use 2 color scale but one color will be fine.
0
votes
2answers
1k views
How can I set up conditional formatting to highlight a range only if all its cells are empty?
I am new to conditional formatting and having a hard time. I have 6 columns with 100 rows. What I would like to have happen is to highlight the row in one color if there is no data in it at all. If ...
0
votes
2answers
852 views
Conditional formatting 2 different colors every two rows
I want to apply conditional formatting to change the background color of alternating rows on a spread sheet. The rows will alternate between two colors (yellow and green) two lines each.
This is the ...
1
vote
2answers
389 views
Conditional Formatting Alternating Rows in Excel
I want to apply conditional formatting to change the background color of alternating rows on a spread sheet. The rows will alternate between two colors (yellow and green).
The only problem is, that ...
1
vote
1answer
2k views
customize excel 2010 highlight track changes
Is there any way to customize how Excel highlights cells on Track Changes? My customer requested us to "highlight anything you've changed by changing text color to red," and I'd like to implement ...
2
votes
1answer
189 views
Format cell in Excel if contents are a number or a function
I understand conditional formatting but I don't see how it can help me. I'm looking at a sheet with many product entries and for most of them I get values from a table (vlookup) while for others I ...
0
votes
1answer
87 views
How to apply conditional fomatting for a MAX value to a range of cells
I have a table that is five cells wide by twenty high with a sum function at the end (e.g. cel A20). I want to highlight the column that results in the highest SUM. How do I use conditional formatting ...
0
votes
1answer
967 views
Excel INDIRECT function and conditional formatting - highlighting a row
I'm having an issue with conditional formatting using the INDIRECT function. I'm doing something similar to Using INDIRECT and AND/IF for conditional formatting , but the only answer there isn't ...
1
vote
3answers
4k views
conditional formatting for subsequent rows or columns
I have data in a range of cells (say six columns and one hundred rows). The first four column contains data and the sixth column has a limiting value. For data in every row the limiting value is ...
0
votes
2answers
129 views
Restricting symbols allowed in cells of Excel spreadsheet
I need to format some Excel cells to allow currency (decimal point) only to be entered. Some employees completing the form enter a colon (:) instead of a decimal point which then results in an ...
0
votes
2answers
138 views
Finding duplicates in a column where the cells hold a formula
I have a workbook with 3 sheets. Sheet "PS", column A contains a list of player names that stays static. Each week, each person in column A sends me a name from an available list. They are allowed ...
4
votes
3answers
3k views
Highlight a row where a value changes relative to previous row (Conditional Formatting?)
I have a spreadsheet with lots of data. The data is grouped so that all the rows with a certain value in one column (say C) are grouped together. I want to highlight the "boundaries" - i.e., the first ...
1
vote
1answer
1k views
Excel Conditional Formatting of Rows based on multiple columns
I have a spreadsheet with columns A-K and rows 1-56. If any value in D3 through J3 goes below 0, I want the entire row (A through K ) to have a special format. I've gotten close in Excel 2010 by using ...
