-1
votes
1answer
34 views

Conditional Formatting from Helloh, for a Noob

I'm going to try my best to explain what I need to figure out. Also, for you to understand exactly how mind bending this is for me, I haven't used an Excel formula since 2005/2006ish. We're doing a ...
4
votes
1answer
252 views

Excel: Dual graded color scales

Is it possible to do conditional formating for two graded color scales over the same cells? For example I wish to conditionally format a cell such that its color is: Green to Blue graded scale for ...
0
votes
0answers
73 views

Using variables to conditionally format Pivot Table in Excel 2007

I have data in a Pivot Table which I need to conditionally format. How can you do this using one column as a variant to determine the colour of the corresponding cell (e.g. Region and then Month, then ...
2
votes
1answer
331 views

Excel Conditional Formatting cell's value that has number suffix, like 99th, 23rd, or 1st

So I am filling a cell with Blue, Green, Yellow, or Red based on a Percentile Rank that is returned, that is numbers like ( >=90th=Blue, >=60th=Green, >=30th=Yellow, <30th=Red ) Currently ...
0
votes
1answer
782 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
125 views

Excel, Pasting text with hyperlinks, conditional formatting for doubles

I have a list of names that I paste, individually, from a site into a column of cells in a table. I have conditional formatting to tell me if there are doubles. However, when I copy straight from ...
0
votes
1answer
594 views

Conditionally formatting a cell in a pivot table based on a range of cells grouped by a Column Label

Within my pivot table I currently have cells conditionally formatted- Value=1, Green and Value=0, Yellow. I would like to conditionally format based upon all the values within a row label underneath a ...
0
votes
2answers
295 views

Highlight row when two columns contain specified values

I have 2 columns "N" and "O" . Both columns can contain "x". If column N has an x and column O is null then highlight the line. This should apply to the entire worksheet. Thanks so much in advance. ...
0
votes
1answer
1k views

Excel 2007 conditional formatting rule using formula to highlight a row based on matching text between columns

I am checking accountability of whether my office is creating source acknowledgement reports "C", recommended whenever a reference document "A" is read, and required whenever an article "B" is ...
1
vote
3answers
194 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 ...
0
votes
3answers
206 views

Excel: How to format each group of data separately

Is it possible to automatically color each row of data, so that the beginning and end of each day is more visible? Do you think I can do that with conditional formatting? Something like the following ...
-1
votes
1answer
695 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
1k 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
137 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.
1
vote
1answer
238 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
7k 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 ...
0
votes
1answer
2k views

How to let Excel 2007 display a certain text as long/soon as a cell is empty? [duplicate]

Possible Duplicate: custom format for cells with nothing in them without using conditional formatting I'd like Excel 2007 to display a certain text like "" as long as a cell is empty. So ...
0
votes
1answer
263 views

Conditional Formatting with more than one variable

If ( cell A10 =2 ) AND ( cells C10:c15 through d10:d15 are blank) Then color cells c10:15 through d10:15 red I can do one or the other but can't figure out how to make it meet both criteria prior ...
1
vote
1answer
112 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
1answer
692 views

Excel 2007: finding duplicates ACROSS multiple columns [duplicate]

Possible Duplicate: Excel 2010 conditional formatting: selectively highlighting duplicates First of all, this is basically a cut-and-paste of another question regarding Excel 2010. When I ...
1
vote
1answer
557 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 ...
0
votes
1answer
1k 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 ...
5
votes
1answer
6k 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 ...
1
vote
1answer
456 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 ...
4
votes
1answer
16k 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 the cells having a distinct value a unique color without manually creating a conditional ...
0
votes
2answers
1k views

Apply strike out text on row

I have a question about Excel 2007 and I'm not sure if its even possible, but if any community can help it's here. I want to strike out all the text for all cells in a row if the text in column A ...
1
vote
1answer
960 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
1answer
123 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
2answers
3k views

Excel Conditional Formatting Offset Greater than

I need to create a conditional formatting rule that will apply some color if the cell to the left has a value greater than 500, however it is not accepting my formula: =OFFSET(0,-1) > 500 Can ...
1
vote
1answer
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). ...
0
votes
3answers
381 views

CF: Cell STATUS + Cell DATE compared to NOW(DATE) = Colour

If the status in cell $D5 is "AWAITING FEEDBACK" I want to compare the DATE in cell $H5 against TODAYS DATE and CONDITIONAL FORMAT cell $H5 using the data bars formatting (colour to transparent). If ...
5
votes
2answers
3k views

Colour coding blocks of rows using conditional formatting

My macros have been taken away; never to be used again! I'm gutted. I now need to use formatting to help me highlight the different users and their data. Doing this manually is a chore. Using Excel ...