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
1answer
145 views

Excel auto format cell's font size based on number value?

I want to make cell's number values to be smaller, in font size, with small values i.e. the bigger the cell value is, the bigger is the font size. I can only find Data Bars in Conditional ...
0
votes
1answer
116 views

Custom format to display percentage with plus/minus sign

Suppose I have cell value 0.465 and I want to display it in the spreadsheet in green as +46.5 if it is positive and -46.5 if it is negative. I have applied the following format ...
0
votes
1answer
23 views

Change background color of rows which are present in another column

I have data in the A and B column. B column's data is mostly duplicates of A's data, but not always. For example: A Budapest Prague Paris Bukarest Moscow Rome New York B Budapest Prague Los Angeles ...
0
votes
1answer
23 views

Excel Title Row — Not part of the count when using conditional formatting

I would like to set my Excel document to color every tenth line in the document using conditional formatting -- without counting the header row as row 1. Is there any way to accomplish this?
0
votes
2answers
273 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 ...
0
votes
2answers
3k 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
2answers
77 views

How to put conditional formatting in a cell from another excel worksheet [closed]

It's hard to describe what I want, I'm not really familiar with Excel condition terms but it is basically just like this: Worksheet= Dr. castro patient consultations A B C D E ...
0
votes
1answer
970 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
1answer
570 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
1answer
64 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
1answer
79 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
3answers
5k 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
2answers
937 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
1answer
195 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
1answer
2k 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
1answer
3k 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
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
3k 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
395 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
24 views

How do I apply conditional formatting to many workbooks?

I have 120 similar excel workbooks. They each have one sheet containing a small customer databases. I want to apply conditional formatting to all these workbooks. I can do it in one workbook. Is ...
0
votes
0answers
25 views

Excel: Conditional formatting for column merge

I'm looking to create a timetable that is formed by combining material from several worksheets. It does not seem to be possible to automatically consolidate text from several worksheets, but it is, of ...
0
votes
1answer
35 views

Finding Clustered/Consecutive Values in Excel

I am trying to find values in an Excel spread sheet where numbers greater than 0 will be highlighted. However, those highlighted must be clustered, consecutive numbers which should be (at least) three ...
0
votes
0answers
10 views

Conditionally change colors of events in calendar on mac?

Is it possible to conditionally change colors of particular events in calendar for mac ? the same way week cal on iOS works? Maybe with applescript? I havent found any apps for mac that can do that. ...
0
votes
3answers
37 views

How to highlight where a number in another cell falls in a column? Bracket it with the next highest and next lowest?

This is probably an easy fix. I have one cell (Cell B8) with say the number 2000 in it. I have another column of 6 numbers (Cell A1 to A6) (Say 4000, 3050, 2100,2100, 1150, 200) that will change with ...
0
votes
1answer
19 views

Apply conditional formatting to one cell based on part of a text in a cell

I have a spreadsheet containing a bank statement. In C I have a description of what the transaction is for sometimes just a word and other a sentence. In D I have money coming into the account and E I ...
0
votes
1answer
19 views

How do I create a conditional format with 2 columns

I am trying to create a rule that would highlight a cell under these conditions: Column B>1 & Column C=O I want Column C to highlight if they meet these two conditions. Can someone help?
0
votes
0answers
27 views

Formatting of dates in cell using Excel to show result as numbers

I am working with calculating the difference in years, months and days between 2 dates. My results are showing as eg. 32 years, 9 months, 3 days. How do I format the cell to show a result 32 9 3? I ...
0
votes
1answer
27 views

Conditional Formatting for Excel Greater than

I have applied a rule if the cell is greater than 50 fill with cell with RED. The cells are populated from another location. When I apply the rule the blank cells show up RED? Any help would be ...
0
votes
1answer
33 views

Format row that is different than the preceding VISIBLE row

I have an Excel sheet as a database, where each row has a category, and are always sorted by category. Category Item 1 AAA jjj 2 AAA kkk 3 AAA lll 4 ...
0
votes
1answer
47 views

IF AND conditional formatting not working - Excel 2013

Okay so I’m trying to format cells that are blank and meet the logical test. Here’s the formula: =IF(AND($B2="Y", ISBLANK($C$2:$F$172)), TRUE, FALSE) If both tests are true (B column = Y and there ...
0
votes
0answers
11 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
41 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
28 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
62 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
27 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
43 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
98 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
90 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
426 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
96 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
37 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
70 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
65 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
280 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
47 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
183 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
52 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
192 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
1k 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
95 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 ...