**-3**

votes

**1**answer

46 views

### Calculate date difference and color a cell depending on the value with Excel [closed]

I am creating a spreadsheet where I will keep track of the number of days a particular equipment has been borrowed. So far I have the starting dates (when the equipment was borrowed). What I'm ...

**0**

votes

**3**answers

45 views

### Adding a date to a formula in excel [closed]

=$M2="COMPLETED"
I am using this formula to shade a row when COMPLETED is written in column M, but I would prefer the 'date' or 'COMPLETED and the date' but can't seem to work out how to do this.
...

**-1**

votes

**1**answer

23 views

### Formatting - conditional - vlookup- values from one cell to another different worksheets based on value

I would like to be able to enter a part# in column L of sheet 2 and a formula would look through column A of sheet 1 for a match, and then return their price from column F of sheet 1 into column K of ...

**1**

vote

**0**answers

21 views

### Google Sheets: Format number as Mhz/kHz, or MB, kB etc [migrated]

I want to make a spreadsheet with Google Sheets to compare microprocessor's specifications. One column will show processor speed, another will show program space, another for RAM space and so on.
...

**1**

vote

**1**answer

61 views

### Excel VBA - Conditionally format a cell using 2-color scale based on 2 values (max/min) on other cells

I'm trying to write VBA codes to conditionally format (2-color scale) cell A1 based on its value that between is >= cell A2 and <= cell A3. I'm using cells A2 and A3 so I can change the specific ...

**0**

votes

**1**answer

15 views

### EXCEL: Icon Conditional Formatting Based on Range of Values

I am creating a spreadsheet for work and I need to format cells such that I get a green check mark when the value in the cell is between 100 and 101, yellow ! if it is between 97 and 100, and red X if ...

**1**

vote

**3**answers

14k 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?

**8**

votes

**3**answers

8k views

### How do I keep Conditional Formatting formulas and ranges from automatically changing?

I've found that Conditional Formatting formulas and ranges will automatically adjust when you copy, delete, or move data around in a spreadsheet. While this is a nice idea, it tends to break things ...

**1**

vote

**1**answer

28 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

**1**answer

25 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

**1**answer

19 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

**0**answers

27 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

**0**answers

44 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

**1**answer

25 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

**1**answer

33 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 ...

**24**

votes

**8**answers

104k 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?

**5**

votes

**9**answers

36k 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

**0**answers

41 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

**1**answer

228 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

**1**answer

47 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

**4**answers

525 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

**1**answer

186 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

**3**answers

5k 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

**0**answers

14 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

**1**answer

1k 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

**3**answers

43 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

**1**answer

107 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

**1**answer

53 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

**1**answer

42 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

**2**answers

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

**2**answers

53 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

**1**answer

49 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

**1**answer

30 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

**2**answers

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

**1**answer

17 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

**1**answer

249 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

**3**answers

84 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

**0**answers

294 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

**1**answer

21 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

**1**answer

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

**0**answers

29 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

**1**answer

73 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

**1**answer

31 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

**1**answer

44 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

**1**answer

418 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

**1**answer

579 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

**1**answer

37 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

**4**answers

4k 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

**1**answer

66 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

**1**answer

31 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 ...