All Questions
161
questions
2
votes
1
answer
5k
views
Excel 2007 - Conditional Formatting: Compare 3 columns with text - find unique values
I have a spreadsheet with three columns, each column listing the folder names found on a server.
Server1 | Server2 | Server3
--------|---------|---------
A | | A
--------|---------|----...
- 123
0
votes
2
answers
11k
views
Setting background colour of cells based on their string length
Suppose I have this column of data
Canada
Chile
China
...
How do I set the background colour of each cell if the length of the string in it is greater than say 5? ('Canada' cell would be ...
- 101
3
votes
3
answers
13k
views
Excel: conditionally format a cell using the format of another, content-matching cell
I have an Excel spreadsheet where I’d like to be able to create a “key” of formatted cells with unique values, and then in another sheet format cells using the key formatting.
So for example, my key ...
- 133
6
votes
1
answer
2k
views
Conditional formatting to highlight the whole row
I would like to highlight the whole row 5 if J5="T".
I used to do it with the old Excel, the 2010 conditional formatting ignores it. So my rule is like this and it does not work. I used the formula $...
- 61
1
vote
2
answers
7k
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 ...
- 300
0
votes
2
answers
256
views
Finding duplicates in a column where the cells hold a formula
I have a workbook with 3 sheets. Sheet "PS", column A contains a list of player names that stays static. Each week, each person in column A sends me a name from an available list. They are allowed ...
- 1
-1
votes
1
answer
565
views
Excel 2007 conditional formatting formula problem
I have the following problem. I have a sheet where the current month should be highlighted. For this I used the formula for conditional formatting. The formula for the first three months is like this:
...
- 543
1
vote
3
answers
511
views
Excel Conditional Formatting for Cell condition in Range
How do I reference another cell in my conditional formatting?
I want an entire range to highlight in green if a particular cell in that range is populated with "y".
- 71
1
vote
2
answers
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" ...
- 299
1
vote
4
answers
5k
views
Excel: struggling to use CF to highlight differences between columns in the same row
I have a list of vaules in column A and column B. I need to highlight where there is a difference between values that are in the same row.
I've used a simpe formula in B1: $A1<>$B1 (format bold). ...
- 1,538
4
votes
2
answers
3k
views
Excel conditional formatting based on a formula
I would like to use Excel's conditinal formatting of a particular column based on values in two other columns.
I have values in columns A, B, C and D.
column A has text values (any value user enters)
...
- 2,046