Spreadsheet feature that allows automatically adding color, text styles, etc. to certain cells or ranges of cells based on the data workbook

learn more… | top users | synonyms

2
votes
1answer
27k views

How can I express “if column A is greater than column B, format column B”

I'm having trouble with conditional formatting- so would really appreciate some guidance! I want to format the numbers in column B, relative to the values in column A. So if B is equal to or greater ...
2
votes
1answer
3k views

How to change cell color based on today's date in Excel 2010

How do I Change cell color in Excel 2010 for upcoming or past dates based on 90 days from today. I would be great if I could use 2 color scale but one color will be fine.
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
47 views

How can I use conditional formatting or a macro to italicize duplicates (but not the original) cells?

I have a spreadsheet in which there are many duplicates (intentionally), and I would like to highlight the duplicates but not the first instance of a cell. Below is an example row: A A A A A B B B C ...
2
votes
1answer
151 views

Lock color scale (convert to fixed)

I have used conditional formatting to apply a color scale to a range of values. Now I would like to permanently freeze those colors. I have poked around a bit, and can't find event the beginning of ...
2
votes
1answer
5k views

How do i right align an icon set arrow under conditional formatting so that both number and arrow are on right side of cell neatly together?

Cell displays a conditional format arrow Icon set which is on far left side of cell. The number in that cell is right aligned and I want to bring the arrow directly next to the number. I want the ...
2
votes
1answer
4k views

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

I have a column that contains the data and a set of rules for the conditional format of the cells. i.e. the conditional format changes the background colour of some cells if they are negative. I ...
2
votes
2answers
75 views

Color every Cell that contains the number '0'

My problem is most likely a completely trivial one, but at the moment I'm completely out of ideas. I want to color all cells in a certain working area depending on what single digit number they ...
2
votes
1answer
733 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 ...
2
votes
1answer
138 views

how can I use conditional formatting in excel to search for a list of values

I have two columns of data, one which contains a large number of values (column a), while the other contains a smaller amount of values(column e). I was wondering if anyone knew how to search for and ...
2
votes
1answer
157 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.
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 ...
2
votes
1answer
1k 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
537 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 ...
2
votes
1answer
212 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. ...
2
votes
2answers
114 views

Excel conditional formatting rows to highlight weeks in different colours

I am trying to automatically format the rows of my worksheet based on the date in the A column. I am using the following to highlight the weekends. =WEEKDAY($A6,2)<5 This works however I also ...
2
votes
2answers
157 views

A Conditional Format to change the background color but keep the Date format

I have and OpenOffice Calc document that has a "table" with Text, Numeric and Date columns. I have a conditional format making every odd row have a different background color so it will be easier to ...
2
votes
1answer
1k views

How can I use Excel data bars to format cells with text values?

I'm creating a spreadsheet for project planning and have a column that lists estimated effort as follows: Unknown Very High High Medium Low Very Low None I like the visual cues provided by ...
2
votes
3answers
8k views

Vertical Histogram in Excel with Conditional Formatting

I'm able to do data bar conditional formatting in Excel 2010, but I can't figure out how to switch the bar axis to make it vertical. Is there any way around this? Can I simulate a vertical histogram ...
2
votes
1answer
2k views

Excel conditionally format a row based on a cell

I have a table something like this: text1A | text2A | value1A | text3A | value2A text1B | text2B | value1B | text3B | value2B text1C | text2C | value1C | text3C | value2C If the value in column 3 ...
2
votes
1answer
72 views

Highlight rows that don't match other sheet

I'm not sure if this is possible, but I have two spreadsheets that I need to compare in a few different ways. Here is the scenario: **Sheet 1** Column O=Claim Number; Column P=Reserve Indemnity; ...
2
votes
2answers
54 views

Highlight duplicates only if the header is the same

I'm attempting to use Conditional Formatting to highlight a duplicate entry if and only if the Header to both columns are the same. In my example below, this is a season long NFL contest of picking ...
2
votes
1answer
37 views

Excell 2007 conditional formatting

I have created an excel spreadsheet where in each cell there is a formula which gives a value with two decimals. I need to use the conditional formatting to highlight the cells in which the second ...
2
votes
1answer
1k 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 ...
2
votes
1answer
374 views

How to apply conditional formatting only to cells that contain a subtotal formula

I have a list of values, I have to alternate color of each row (that works fine). In that list I also have subtotals, calculated using the SUBTOTAL function. How would I be able to give just the ...
2
votes
1answer
31 views

How to show a value of a Cell as it's displayed

I have a cell A2 that shows the value 001. I want to concatenate that value of 001 to a string to show REQ-001. The cell that I want to show this string I have =CONCATENATE("REQ-",A3). But the ...
2
votes
1answer
118 views

How to search Excel conditional formatting formula with specific text

Sorry I did try to search but could not find a question similar to what I want. My Question: Is there any easy way I could search all conditional formatting that has formula with specific text? I ...
2
votes
1answer
173 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 ...
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
3answers
9k views

EXCEL: How to conditional format a thick bottom border to an entire row based on one column value? [duplicate]

Possible Duplicate: Excel conditional formatting to highlight entire row if one date is not equal to another date in that row I have the following rows... 1 AA 12 13 4 7 1 A ...
1
vote
3answers
3k views

how to get text instead of TRUE:FALSE in excel

suppose I have a formula in cell C3:=AND(A1=B1) it will give TRUE:FALSE but i need Yes:No instead so how do I format the cell C3 to get so? Thanks! Regards,
1
vote
3answers
273 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 ...
1
vote
3answers
48 views

Conditionally format entire row based on a cell value [duplicate]

I know this has been asked before, but I must be missing something. I want to put a border above all rows that contain "Monday". The formula is =$B$3="*Monday*" I thought it might be because ...
1
vote
3answers
2k views

Color scale for text values in Excel

I would like to apply color scale on text values. But unfortunately, it works only on numbers! I’m doing this to easily identify the repeated values sorted by other column. This image explains the ...
1
vote
1answer
6k views

customize excel 2010 highlight track changes

Is there any way to customize how Excel highlights cells on Track Changes? My customer requested us to "highlight anything you've changed by changing text color to red," and I'd like to implement this....
1
vote
2answers
498 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
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" ...
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 so ...
1
vote
2answers
6k 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
54 views

How to highlight 2017 in Excel

I need cells in Excel to be highlighted if they contain 2017 in the date. For instance there is a column that has just dates. Some dates are for 2017. I need to input those dates at a later time. The ...
1
vote
2answers
28 views

Fill a date-filled cell red if older than 30 days and no date paid entered in another cell

I have two cells in Excel that are for dates (date billed and date paid). I need the date billed cell (say A1) to fill red if it contains a date and that date is older than 30 days and nothing has ...
1
vote
1answer
2k views

Alternate Row Colors of Duplicate Data in Excel

I am working with a dataset in Excel that contains duplicate values and non-duplicate values that are numbers. I would like each duplicate value group to have alternating shades via Conditional ...
1
vote
2answers
32k views

Excel conditional formatting if value is between or equal to values

I have been trying to use conditional formatting to create a Gantt chart. So far I have not been very successful. Here is a screenshot of part of the chart: The current formatting is hand made. I ...
1
vote
1answer
70 views

Conditionnal Formatting with Dynamic Custom Formatted Date

My problem is that I want to color in red a list Custom Formatted Dates when the date is overdue. For instance, I got two actions: Buy Bread : Must be finished before 27/01 Buy Milk : Must be ...
1
vote
4answers
10k views

Preserve conditional formatting on cut-paste

I have some data from different sources that I'm trying to line up to get a good handle on which fields they have in common and which they don't. To make it easier to see rows, I set up a conditional ...
1
vote
2answers
1k views

Conditional Formatting Alternating Rows in Excel

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). The only problem is, that ...
1
vote
1answer
302 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 ...
1
vote
1answer
29 views

Conditional formatting if an input cell is blank in a row marked completed

I want to highlight any blank input cell in a row if the row is labeled as completed in column B. There are several columns with information being entered in them and I would like to use this as a ...
1
vote
1answer
111 views

In excel 2010 how do I change the cell colour to red if the date entered is 2 weeks or more in the past? [duplicate]

I have a spread sheet and I want the colour of the cell to change to red when the date entered is two weeks (or more) ago as this will immediately show me when work is overdue so I can chase it up. ...
1
vote
1answer
46 views

Excel Conditional formatting if in list

I have a list of values J1:J100 and another list of values E1:E75 If a cell in column J matches a cell in column E, I would like this cell to be highlighted. Any ideas what formula to enter into ...