All Questions
161
questions
1
vote
2
answers
97
views
Highlight differences in multiple columns including False, 0 and blank?
Related to this question, I am trying to compare a table of settings to identify some configuration issues. I am using the following formula to highlight differences between two known good configs (...
- 1,943
0
votes
1
answer
420
views
Using conditional formatting to identify formulas (Excel 2010)
I have a long sheet where some cells have typed values and some other cells have formulas. And i need to have a visual identification of the kind (number or formula) of each cell.
Is it possible to ...
- 33
0
votes
3
answers
407
views
IF nesting formula, showing "too many arguments" error message
Given the following formula:
=IF(D7="ACCOMMODATION","$220","",IF(D7="DINNER","$52.80","",IF(D7="LUNCH","$31.00","",IF(D7="BREAKFAST","$27.55","",IF(D7="INCIDENTALS","$19.70","")))))
D7 cell has a ...
0
votes
1
answer
502
views
Conditional formatting group of cells in repeating pattern within range - grey out old dates on calendar
I have made a calendar in Excel with each day being 2 cells wide and 9 cells tall. The first cell (top left) contains the date. An example cell might be the range from A2 to B10 with the date in A2. ...
- 121
2
votes
1
answer
482
views
Multiple conditions in custom format
I would like to have multiple formatting conditions eg.
561 -> 561
1,100 -> 1.10K
2,220,000 -> 2.22M
45,200,000 -> 45.20B
I came up with following solution but it wont work:
[>=...
- 33
0
votes
1
answer
50
views
Highlighting cell using if condition
Here is my excel sheet:
----------------------------------------------------------------
| | A | B | C | D | E |
----------------------------------------------...
- 3
1
vote
2
answers
5k
views
How to use values from imported CSV in Excel formulas?
I have an Excel 2016 spreadsheet that uses a CSV file as a data source. I would like to use conditional formatting and formulas to visualize that data more easily.
The problem is that formulas and ...
- 1,271
0
votes
0
answers
485
views
Excel formula to format cell compared to the cell above
I have numeric data between columns F-N.
I want to conditionally format cells based on the cells above, using a single formula across the range.
I'm using =$F$6:$N$6<$F$5:$N$5 as Formula but it ...
- 145
1
vote
2
answers
21k
views
Condition formatting based on TRUE/FALSE output of another cell
I have 2 tables:
containing values
containing TRUE/FALSE outputs based on a formula that depends on the values of Table 1
I would like to apply condition formatting so that Table 1 cells are color ...
- 11
1
vote
2
answers
416
views
Filter for Duplicates or Highlight Unique Responses Across Multiple Columns in Excel
I am trying to filter or highlight the results of a Survey with lots of response options, some of which repeat.
E.g. List your favorite animals
Name B C D E F
Bob ...
- 11
0
votes
1
answer
384
views
Compare excel column from different files
want to compare two different excel files in a way that if column A (file 1) match column A (file 2) then check for differences between column B (file 1) and column B (file 2)
- 1
0
votes
1
answer
1k
views
Format blank cells based on text in another cell
I would like to apply conditional formatting to a sheet, however, cant figure out the right formula.
The formatting would only apply to BLANK cells in columns S to AT based on text in in column I.
...
1
vote
1
answer
2k
views
How do I conditionally format all rows in a table, to display a different colour based on a cells value
I have developed a table (as seen below) which is designed to show a persons duties based on priority.
If a person clicks the toggle on/off button, this will toggle colours on the rows of the table, ...
- 27
1
vote
1
answer
2k
views
Excel: count number of conditionally formatted rows
I have an excel sheet in which I apply conditional formatting on two columns. The row is only highlighted if the cells in that row meet the condition. Specifically, I want to highlight rows where the ...
- 11
2
votes
2
answers
3k
views
How do to underline rows in excel based on unique data?
I'm trying to automatically underline certain rows based on unique project IDs in column 1. Please see example table attached. Each Project ID may have different number of rows associated each time ...
- 21