**0**

votes

**1**answer

20 views

### Conditional formatting in Excel 2013

Hi I want use conditional formatting. On this values:
everything works, but when i change values (mid and max values are similiar) to:
conditional Formatting do not works. What I do bad?

**0**

votes

**1**answer

4k views

### Conditional formatting to highlight the whole row if a cell is left blank

Could anyone tell me please how to highlight a row if the first cell in that row is missing a value?

**0**

votes

**1**answer

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

**0**

votes

**2**answers

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

**0**

votes

**1**answer

221 views

### How do I format each cell in column FOO in Excel if the len() of the cell value is longer then BAR?

If this is the wrong place to ask this let me know.
Here is the formula I have right now:
=LEN($A$2)>$AB$11
Applies to:
=$A$2
That works great for the one cell. I need it to apply to each ...

**0**

votes

**2**answers

53 views

### Correct use of the Formula type in Excel Colour Scales

I'm trying to work some trickery in excel where each cell in a row is shaded based on how many have been completed:
So the idea is that as more of the columns in the row are ticked the whole row ...

**0**

votes

**1**answer

84 views

### How to format cells between two dates with a colour based on a value in vba?

(apologies if this question is difficult to understand, i'm unable to post an image)
I've tried finding a solution for this online but haven't had much luck.
Ideally, I want to use conditional ...

**0**

votes

**1**answer

48 views

### Automatically format currency based on adjacent column - Excel

Using Excel and need a little help with a simple formula.
I know conditional formatting should do the trick here, however, I need help creating the exact formula for my need.
In column A I write the ...

**0**

votes

**1**answer

39 views

### Is it possible to get array/CSE formulas to work with conditional formatting?

I am trying to get a CSE formula to work with conditonal formatting. When using CSEs with cells, you hit CTRL+SHIFT+ENTER, but it appears that this key combination doesn't register in the conditional ...

**0**

votes

**1**answer

44 views

### Conditional formatting duplicates for highlighted cells

I would like to conditionally highlight cells in a row. When the items in column B are duplicates then cells in columns B and C should be highlighted.
The value 7264 in column B has duplicates so ...

**0**

votes

**3**answers

923 views

### For Excel how do I create a field that automatically generates a sequential number

How do I create a field that automatically generates a unique number when I enter a new record in a table ?
I have a list of numbers in the B column. I want the numbers in column A to automatically ...

**0**

votes

**2**answers

175 views

### Conditional format cells that are duplicated in every column

I have a table in which every column describes a product and every row is responsible for one attribute of the product. I want to highlight cells which are duplicated in every column.
I have for ...

**0**

votes

**1**answer

140 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

**1**answer

503 views

### Why am I getting unexplained vertical lines in the center of merged cells?

I am working on a spreadsheet that merges 20 columns into a single row. This row is conditionally formatted to display a data bar, of a proportional length based on a set of values from 0 to 275 that ...

**0**

votes

**1**answer

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

**2**answers

2k 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

**2**answers

2k 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 ...

**0**

votes

**3**answers

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

**0**

votes

**0**answers

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

**0**

votes

**0**answers

153 views

### VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows

I have a range (the image below).
Please note that:
Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table'
The number of columns, ...

**0**

votes

**1**answer

39 views

### How can I set up this conditional formatting in Excel 2010?

We create sections by highlighting an area in Excel 2010 and clicking ALL BORDERS. We want to set it so that any time you type "REPLA" between columns J and Q, the line that "REPLA" is in will Fill ...

**0**

votes

**1**answer

55 views

### How to change a row of cells on excel 2010 depending on different cell data

Can anyone help me with a problem I'm having on excel 2010 please?
I am trying to change the colour of part of a row of cells when certain data is input. For example I want cells A13 to G13 to ...

**0**

votes

**1**answer

57 views

### Excel - Using condtional formatting in a count down of the date

So i am using Excel Mac 2008, i want a formula where i enter a date and if the date is less than 5 days from today, it turns bold and red. can anyone help me figure this out?
I have a formula that ...

**0**

votes

**0**answers

97 views

### How to copy a column with conditional format by “value” - Libreoffice 4.1

I have a column with data and a conditional format that change, for instance, the background of some cells.
I would like to copy this column with the resulting format in another place "by value",
I ...

**0**

votes

**0**answers

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

**0**

votes

**0**answers

21 views

### my toggle formula appears to be interfering with my conditional formatting

My toggle formula appears to be interfering with my conditional formatting.
This formula
{ =IF(K805=TRUE, "8 Cmplt", "2 Pending") }
yields me a working toggle button but it doesn't turn the ...

**0**

votes

**0**answers

13 views

### Conditional Formatting for entire ROW based on a cell entry number in a particular column [duplicate]

I am looking for how to have conditional formatting for a row if a certain cell has a certain number in it.
If a cell in column J has the number 284 in the cell, then the whole row (cells A - J ) ...

**0**

votes

**0**answers

29 views

### Copy the results of conditional formats which use sums to colour cells

I have set up a number of rules in some conditional formatting which results in colouring cells on a sheet of about 2,500 rows. I need to be able to copy the resulting formatting colours, to issue ...

**0**

votes

**0**answers

41 views

### Use the formatting from data table cells for drop down table results

I am setting up a risk ranking table and risk analysis spreadsheet in Excel 2010
The user selects from two drop down boxes (liklihood and consequence) and it gives the corrosponding result. I have ...

**0**

votes

**0**answers

20 views

### How to conditionally format cells in excel based on whether contents is a formula or text/number [duplicate]

I'd like to conditionally format cells in Excel based on whether they contain a formula or not. If it's a formula I don't want formatting to change, if somebody overwrites contents of the cell with ...

**0**

votes

**1**answer

64 views

### How do you have a conditional formatting rule in Excel apply to a discontiguous range of cells?

I have an Excel workbook with 10 worksheets.
Each sheet has a column named status.
Depending on the value of status ("on time", "at risk", "completed"), I want to format the cell background with a ...

**0**

votes

**1**answer

86 views

### Account based Conditional Formatting

I have two accounts in Outlook 2013, my work Exchange account and my personal Hotmail account. I am trying to conditionally format the tasks and emails in my To-Do List based on which account they ...

**0**

votes

**2**answers

353 views

### conditional format that would highlight an entire Row based on two criteria

Can someone help me please with a conditional format that would highlight an entire row in Excel 2010 if column B on my spreadsheet has any of these Letters (A,B,C,D,E,F,G,H,Z) and column C has the ...

**0**

votes

**0**answers

285 views

### OPEN OFFICE CALC - How do I use conditional formatting give me a background based on the distance from a date AND value of a cell?

If I have "Alpha", "Bravo" or "Charlie" in column "A" and "Annual", "Semi-Annual" or a blank cell in column "B", How can I use conditional formatting to change the background color of a cell in the ...

**0**

votes

**1**answer

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

**0**

votes

**1**answer

181 views

### Conditional Formatting to highlight dates past due

I have a spreadsheet which indicates when dates listed in Column N are coming up within the next 30 days (red, italic text) or are overdue (red, italic text and yellow cell fill).
I have achieved ...

**0**

votes

**1**answer

483 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

**2**answers

271 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

**1**answer

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

**0**

votes

**1**answer

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

**0**

votes

**0**answers

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

**0**

votes

**2**answers

177 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

**2**answers

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

**0**

votes

**2**answers

176 views

### Conditional Formatting Non Contiguous Ranges

I have a large spreadsheet, which came prepopulated with data. What I would like to do is the following. If I select I7:15, and apply this conditional formatting
Cell Value is equal to =G7, colour ...

**0**

votes

**0**answers

32 views

### Excel: use formula in cell format [duplicate]

Possible Duplicate:
Excel: use formula in cell format
Is there a way to use a formula as a cell format?
AFAIK, conditional formatting allows only static format applied based on some ...

**0**

votes

**1**answer

602 views

### Outlook 2007 - Conditional Format based on Users declining a meeting

I recently set up a meeting with a colleague but must have ignored the fact that he had declined. So I showed up to the meeting alone.
Is there any way to conditional format my Outlook 2007 calendar ...

**-1**

votes

**1**answer

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

**-1**

votes

**1**answer

1k views

### Changing a row's color depending on the value ( TEXT ) of a cell [duplicate]

In a cell, I have the choice of YES and NO for values. I would like to know how to change the background color for other cells in the same row depending on the value of the first without changing the ...

**-1**

votes

**1**answer

432 views

### Excel 2007 conditional formatting formula problem

I have the following problem. I have a sheet where the current month should be highlighted. For this I used the formula for conditional formatting. The formula for the first three months is like this:
...

**-1**

votes

**1**answer

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