A feature in Microsoft Excel, LibreOffice Calc, and some other spreadsheet programs that allows the user to automatically add color, text styles, and so on to certain cells or ranges of cells based on the data in the spreadsheet.

learn more… | top users | synonyms

0
votes
2answers
3k 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
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
3answers
391 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
0answers
10 views

Conditional formatting based on text [duplicate]

Does anyone have a conditional formula/s that can compare text in two different cells? I have a scale A-E and want to compare against another cell for eg: highlight a1 green if a1=A b1=D, but it also ...
0
votes
1answer
30 views

Can I use conditional formatting to format a cell based on color in the cell itself and the cell before?

Conditional formatting Excel 2010 how to format a cell based on color in the cell itself and the cell before. I have with Conditional formatting marked a start cell and end cell with red I want to ...
0
votes
0answers
17 views

Can I copy graduated scale conditional formats with relative references?

I have a number of columns, each populated with numbers. I want the color of the cells in each column to be conditionally formatted on a 3-color graduated scale, against the value in a single cell at ...
0
votes
1answer
41 views

Excel conditional formatting for repeating values

I have a table of data where there are 50 rows and many columns. Each column's value is sorted by the most important result at the top. These are names of people in sports. I would like to see ...
0
votes
0answers
23 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
1answer
36 views

Conditional Formatting with Unequal Row Elements [duplicate]

I have an Excel table. I want to highlight the rows in which at least one element is different from the others for a given row. How can I do that? An example: PRODUCT COLUMN 1 COLUMN 2 ...
0
votes
1answer
50 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 ...
0
votes
1answer
57 views

How can I make Excel conditionally highlight cells based on the contents of cells? [duplicate]

I have a few things that I would like to do on Excel: How do you highlight a row [A-U] if only the first cell A has had text entered in it? When you enter text in cell A cells B-U have a yellow ...
0
votes
1answer
222 views

Conditional format cells, based on their text value in Libre Office

This is driving me crazy. I try to set up the simplest conditional rule, but it will not work: format cells based on their text value. The sense is to colorize a separator line. Until now I had ...
0
votes
0answers
78 views

Change value color in a specific column/row/cell if not equal to another specific column/row/cell

I have column A and column B. Column B's rows contain one of the values A, B, C, or D. The user needs input in column A any change to the value in column B. If there is no change, or the value is the ...
0
votes
2answers
23 views

Excel 2010 Custom Formula / Conditional Formatting to highlight data that is greater than Twice the Value of Original Cell

I am trying to figure out how to indicate cells that are greater than twice the value when compared to a specific cell. For example, a value of .1 compared to .18 would be OK but .1 compared to .2 ...
0
votes
1answer
58 views

Excel 2010 Conditional Formatting

I have a spreadsheet for taskers with due dates. I have used conditional formatting to change the font color to red for pass due and yellow for approaching due dates...now i need to add another ...
0
votes
1answer
43 views

Highlight Duplicates Not Next To Each Other Using Conditional Formatting

We have a list of parts in Excel in a certain order. For reasons I won't get into, we need to highlight when there are duplicates that aren't next to each other. Currently, I'm using this formula in a ...
0
votes
1answer
104 views

Is there anyway to format negative numbers in red in a table in Powerpoint 2010?

I have tables of data and I want the negative numbers to show up in red (similar to what you would do in Excel). Does powerpoint have this capability?
0
votes
0answers
43 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 ...
0
votes
0answers
148 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 ...
0
votes
1answer
47 views

Conditional formatting

What I am looking to do is have a conditional format set up so that if row G contains the value "In progress" "With 3rd Party" or "Identifying" and row H, J or K contain no value then highlight rows A ...
0
votes
0answers
163 views

conditional formatting of pie chart segments

i have a very simple pie chart - developed in excel for mac 2011. each segment of the chart represents a 'group' and is sized relative to a column of data called 'count'. there is a second column ...
0
votes
1answer
758 views

Conditional Formatting for one cell value in a list, another cell blank

Looking for how to do Conditional Formatting for the following rule: If a number in a cell equals one of a list of particular numbers, then information MUST be entered into an additional cell. ...
0
votes
2answers
81 views

Excel Formating - How do I compare 2 cells and highlight one of them based on the date in 1 Col being further out then the date in the other?

I have a spreadsheet tracking multiple dates for about 150 people. I am having a problem however getting dates in Col I to highlight if they are going to be past the date in Col P. I want Col I Row ...
0
votes
2answers
89 views

Selectively find duplicates across columns

Column A has the product ID. There are 102 other columns with other data. Column A will be unique unless some data was changed. In that case, there will be 2 rows with 99% of the columns are ...
0
votes
0answers
785 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. ...
0
votes
1answer
175 views

Conditional formatting in Excel 2013 for C8=blue and bold if C5>C2

This is part of a problem for college for which I can't find a solution. Q: Use conditional formatting to format, in blue and bold, the value in column 8 for which the value in column 5 is greater ...
0
votes
1answer
89 views

How to suppress repeating values in a manner that takes into account previous conditional formatting? (Google Calendar-like scheduling blocks)

I'm in the process of creating a scheduling template. I'm trying to figure out how I create a conditional formatting formula for suppressing repeating values that takes into account the conditional ...
0
votes
0answers
35 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
0answers
328 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
1answer
52 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
1answer
105 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
1answer
249 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
1answer
114 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
1answer
164 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
2answers
744 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
1answer
219 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
1answer
290 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
1answer
894 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
381 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 ...
0
votes
1answer
373 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
0answers
20 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
2answers
277 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
185 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
2answers
291 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
0answers
34 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
1answer
617 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
1answer
38 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
1answer
7k 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
1answer
474 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: ...