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

2
votes
1answer
2k 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
306 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
725 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" ...
5
votes
1answer
19k 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 ...
1
vote
1answer
508 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
3k 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
2k 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
2k 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
999 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
643 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
3k 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.
0
votes
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
122 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 ...
1
vote
1answer
420 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 ...
3
votes
7answers
23k views

Prevents cells from printing in Excel

Is it possible to prevent the contents of specific cells (or entire row or column) from printing in Excel? I need to maintain the cell size. I've been setting the text color to white before printing, ...
1
vote
1answer
128 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, ...
0
votes
3answers
10k 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
2k 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
173 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
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

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 ...
13
votes
2answers
5k 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
382 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 ...
0
votes
1answer
225 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
1answer
612 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 ...
2
votes
1answer
4k 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 ...