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

1
vote
1answer
19 views

Excel: Conditional formatting not filling in cells if adjacent cell is filled

I am trying to fill a pair of cells in if both are blank. Which works unless the cell next to the pair is filled in. How do I go about resolving this issue? Formula: =AND(ISBLANK(F2),ISBLANK(G2)) ...
0
votes
1answer
18 views

Combining the ISBLANK and Date function

I have been searching through forums and can not figure out how to succesfully combine the two functions ISBLANK and a date function. What I need to do is use this formula in google sheets for ...
0
votes
1answer
12 views

how to highlight the cell with the max value

given a range of non adjacent columns (not sure if it matters if they're adjacent) i.e F1:F100,J1:J100,N1:N100 for each row i'd like to highlight the cell with the maximum value. i tried ...
0
votes
0answers
25 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 ...
1
vote
0answers
35 views

How do I use an IF-THEN or Condition Statement for Excel 2013?

What would the condition statement be if I wanted all my sold items to go red in column F, but leave the ones un-shaded that have the word "Received" also in column F? The Headings of my Excel sheet ...
2
votes
1answer
24 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 ...
1
vote
1answer
25 views

How to use Conditional Formatting to change text color to match conditional fill color

I have used the Conditional Formatting to change the Cell fill color based on the percentage number. However, I would like to hide the text so I just have a bunch of colored squares with no value ...
23
votes
8answers
99k 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?
1
vote
3answers
13k 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?
4
votes
9answers
34k 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, ...
0
votes
0answers
27 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
219 views

Conditional formatting in Excel 2013 based on inequality between two cells

This is part of a problem for college for which I can't find a solution. 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
37 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
4answers
312 views

Excel function determine if a cell is visible

In conditional formatting I want to detect if the row above the current cell is hidden or visible. How can I detect if a cell is visible or not? The only hack I can think of is: Create a column ...
1
vote
1answer
96 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
3answers
4k 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 ...
0
votes
0answers
12 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
1answer
979 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
3answers
38 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 ...
1
vote
1answer
61 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 ...
2
votes
1answer
37 views

How to color rows based on two cell values in Open/Libre Office?

I am trying to apply conditional formatting to an entire row based on two cell values. The style is to be applied only if both cells have a particular value. I tried applying formula of the form: ...
0
votes
1answer
36 views

In MS Excel how do I set the number of decimal places dynamically?

I have a table where I am reporting a range of correlation coefficients which range from -1.0 to +1.0. I want to format them such that if they are plus or minus one or zero, then they are formatted ...
2
votes
2answers
5k 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 ...
0
votes
2answers
33 views

Insert spaces in excel number sequences

I am trying to format cells so when I type in phone numbers it automatically formats them as follows: - Landline Nos e.g. 02012345678 to appear as 020 1234 5678 Mobile Nos e.g. 07123456789 to appear ...
1
vote
1answer
37 views

How to highlight the first cell in a column that matches criteria with conditional formatting

In one column of a spreadsheet I want to highlight the first cell ONLY above a specific number. For example, if a column has values increasing from 0 in the first row to x in the last row, how do I ...
0
votes
1answer
22 views

How to avoid apply to range in copying conditional formatting in excel 2007 [closed]

I want to change the selected cell(A1) colour if its value is greater than other cell(B1) in same row.When i copy this conditional formatting to other multiple cells(A2,A3,A4...) in below rows, it is ...
0
votes
2answers
2k views

Excel INDIRECT function and conditional formatting - highlighting a row

I'm having an issue with conditional formatting using the INDIRECT function. I'm doing something similar to Using INDIRECT and AND/IF for conditional formatting , but the only answer there isn't ...
-1
votes
1answer
16 views

Conditional formatting (alternating between only two colours) of rows depending on cell values

How do i get conditional formatting done depending on values of cells. I need to get the cells (and their rows) formatted in only two colours Say,A1 has Colour1 if A2=A1, then A2 should get ...
0
votes
1answer
172 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
3answers
71 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
0answers
283 views

Excel 2011 Conditional Formatting: compatibility issues

I would like to create a workbook in Excel 2011 for Mac that is fully usable in Excel 2003 (on Windows XP, Compatibility Pack installed). The purpose is a semi-automatic calendar, where one enters ...
0
votes
1answer
20 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 ...
1
vote
1answer
53 views

Alternative to cell highlighting using conditional formatting in Excel without causing freeze/crash

In column A, I have a value and I want to highlight if it doesn't match the same value in column B. I'm using the formula below in conditional formatting which works great. ...
0
votes
1answer
29 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 ...
1
vote
1answer
33 views

Condition formatting dates two week before the actual target date

I have a spreadsheet in excel with a formula that when I enter a date into column A cells, column B cells will enter a date 9 months - 1 day from the date entered in cell A1, A2, A3, etc... Now I ...
0
votes
1answer
394 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, ...
4
votes
1answer
528 views

Excel: Dual graded color scales

Is it possible to do conditional formating for two graded color scales over the same cells? For example I wish to conditionally format a cell such that its color is: Green to Blue graded scale for ...
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 ...
1
vote
4answers
3k 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 ...
0
votes
1answer
50 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 ...
1
vote
1answer
29 views

Get conditional formatting to analyze rows separately

I have a calendar and I am trying to fill the background of the cells based on dates on another sheet. I have gotten it to work by entering the dates in a columns, naming the range (lets says ...
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 ...
1
vote
1answer
44 views

Excel - if cell is empty AND if cell is empty - Colour Row

I'm a complete novice when it comes to conditional formatting. I've found a similar question that allowed me to change the colour of the cell, but not the row. Here's a snipped of what my sheet will ...
1
vote
1answer
42 views

Higlight a specific cell based on ADDRESS() return value

I want to give a style (highlight) a specific cell based on a date value. This date is, say, in cell A1. To achieve this, I thought I would calculate the address of the cell I want to style with the ...
0
votes
1answer
42 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 ...
5
votes
3answers
4k 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
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
64 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 ...