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
202 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
546 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 ...
5
votes
3answers
9k 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 ...
2
votes
1answer
2k 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 ...
2
votes
1answer
168 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 ...
3
votes
1answer
3k views

Excel conditional formatting to highlight entire row if one date is not equal to another date in that row

I'm trying to use conditional formatting to highlight an entire row if the date in column D is greater than the date in column B. I can't seem to make it work. Is it a problem because it's a date ...
1
vote
1answer
3k views

Alternating Row Colour with Conditional Formatting in Excel 2011 for Mac?

Does anyone know how to create a formula that causes the row colour to alternate when using conditional formatting?
8
votes
3answers
34k views

Microsoft Word 2010 - Conditional Formatting

Is there a way to apply conditional formatting to a table in Microsoft Word 2010, in much the same way that it is possible in Microsoft Excel? Thanks.
7
votes
5answers
19k views

Conditionally format a cell if it contains formula

Is it possible to conditionally format a cell if the cell contains formula (to alert myself and other users when updating the cell)?
6
votes
2answers
14k 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
votes
2answers
3k views

Excel conditional formatting comparing date and time to current date and time

I have a style sheet in which I have to dates with times ----------------- 29/09/2011 12:00 29/09/2011 14:00 ----------------- If current date and time is 29/09/2011 11:50 then row is green If ...
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 ...
-1
votes
1answer
500 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
vote
1answer
697 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 ...
8
votes
1answer
33k views

Conditional formatting of TRUE / FALSE values in an Excel 2010 range

I have a range containing formulas that evaluate to TRUE or FALSE. How would one apply conditional formatting to this range, so that TRUE cells are Green, and FALSE cells are RED?
1
vote
2answers
448 views

Advanced spreadsheet auto-formatting

Is it possible to autoformat spreadsheet like this IF A1 = C1 then A1:E1 cells background becomes light gray I use OO Calc, but it's ok if you know how to do it in MS Excel or Google spreadsheet
1
vote
1answer
293 views

conditional formatting of entire row from a cell's value in that particular row in Excel 2007

I have viewed the answer for a similar question. If I have several rules for a particular row, (e.g. if cell A2 is 1 then the row is red, if 2 then row is blue, if 3 then row is green, etc...). Having ...
2
votes
1answer
3k views

How do I use conditional formatting in a spreadsheet based on dates?

I have a spreadsheet in OpenOffice V3.3.0 (used in Windows 7 32 bit). One column contains dates (in the format: 14 August 2011 ) and I want to use conditional formatting on those cells depending on ...
1
vote
3answers
371 views

Excel Conditional Formatting for Cell condition in Range

How do I reference another cell in my conditional formatting? I want an entire range to highlight in green if a particular cell in that range is populated with "y".
1
vote
2answers
1k views

Excel conditional formatting of row

Can someone please tell me how to highlight multiple cells in a row based on some values in any one of a given number of cells? For example, if in Row 2 any of the cells from D2 to L2 have value "A" ...
12
votes
3answers
66k 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 cells having a distinct value a unique color without manually creating a conditional format ...
1
vote
1answer
658 views

Excel conditional formatting multiple repeating rows

I'm using Excel 2010 I have a monthly menu. menu days are listed by row with 2 menu items list for each day. Col-C Col-D Day 1 Cheesburger Hamburger Day 2 Taco Quesadilla Day 3 ...
1
vote
4answers
4k views

Excel: struggling to use CF to highlight differences between columns in the same row

I have a list of vaules in column A and column B. I need to highlight where there is a difference between values that are in the same row. I've used a simpe formula in B1: $A1<>$B1 (format bold). ...
0
votes
2answers
6k 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 ...
2
votes
1answer
3k views

Excel: Detect #N/A (German: #NV) for conditional formatting

I have a huge Excel sheet where I regularly import mass data into. This data is input to calculations per row. Sometimes, the imported data results in a #NV error in the calculated data. I would ...
1
vote
1answer
1k 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: ...
2
votes
1answer
978 views

Conditional Formatting to highlight cells with highest frequency

I have an Excel table like the following: 1 2 3 4 5 6 7 8 ---------------------- 3 3 3 3 3 1 1 1 4 4 5 4 4 4 4 3 and I need a conditional style to highlight the items with the ...
2
votes
1answer
3k views

Excel: Conditional Formatting (Highlighting) Values Based on Another Worksheet

I have a workbook that has two worksheets. The first worksheet is simply a list of the first 78,498 prime numbers in a single column, A1-A78498. The second worksheet has a grid of numbers from 1 to ...
4
votes
2answers
4k views

How can I alternate grid background color in excel when a value of a single column changes?

How can I alternate grid background color in excel when a value of a single column changes? Such as this: I would want to do this with conditional formatting, but I can't figure out how to.
1
vote
5answers
3k views

How to delete all data on hdd other than Windows 7 [duplicate]

Possible Duplicate: What's the best way to completely remove everything from a computer, without re-installing? I have to return my company laptop. It has windows 7 on it. I want a way ...
1
vote
1answer
124 views

Is there a formula that I can use so that I can get a cell on Sheet 1 to have exactly the same formatting as a cell on Sheet 2?

I am using an excel spreadsheet to record skill competencies of staff. Sheet 1 will act as a "master" sheet reflecting the skill competencies of all staff (ie different employee in each column) and ...
2
votes
1answer
519 views

Adding conditional formatting to the status line in GNU screen

In GNU screen in the status it is possible to put conditional things, such as %?%F%{+b r}%:%{+b b}%? %F is the test; if true it turns on bold red formatting %{+b r}, whereas if false it turns on ...
6
votes
11answers
51k views

How to prevent cells from printing in Excel

How can I prevent the contents of specific cells (or entire row or column) from printing in Excel, while keeping them visible on the screen when I'm editing the file? Ideally I should be able to do ...
1
vote
1answer
140 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, ...
2
votes
3answers
18k views

How to hide number but keep Excel cell background color?

I got a sheet like the below figure. I want to hide all the number and just keep the background color. How can I do it?
3
votes
2answers
3k views

Excel conditional formatting based on a formula

I would like to use Excel's conditinal formatting of a particular column based on values in two other columns. I have values in columns A, B, C and D. column A has text values (any value user ...
2
votes
1answer
201 views

Conditional Formatting in Excel

I have a worksheet with a series of rows A1 - H1 etc and a drop down list which lives in H1, I would really like to change the cell styles of all the cells between A1 - H1 based on the value in H1. ...
1
vote
2answers
5k 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
2k views

Conditional Formatting of a Cell Based on Color Value in that Cell in Excel

Is is possible to format a cell based on one component of the RGB value inside of it. For example, let's say I have 3 cells - A1, A2, A3. In A1, I want the cell color to be the shade of red anywhere ...
23
votes
2answers
9k views

Excel Conditional Formatting Escaping a Question Mark

I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn ...
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
419 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
4answers
5k 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 ...
0
votes
1answer
241 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 ...
34
votes
8answers
151k views

Find Items in one column that are not in another column

I have two columns in Excel, and I want to find (preferably highlight) the items that are in column B but not in column A. What's the quickest way to do this?
0
votes
1answer
625 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 ...
3
votes
2answers
8k views

Excel - conditional formatting in Shapes?

For a long time, I didn't think it was possible to have a Shape (e.g., Text Box) have a value set by formula, but it turns out you can. Similarly, it appears that you can't apply conditional ...