All Questions
161
questions
18
votes
9
answers
74k
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 with ...
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 $...
4
votes
2
answers
30k
views
Highlighting Cells in Excel based on the Value Associated with the Cell
I have two sheets:
Users in their respective groups and
A compilation of those same users with an expiration date.
I'd like to highlight any cell in the the first sheet if their respective date ...
4
votes
1
answer
9k
views
How to apply a single conditional formatting rule to multiple non-contiguous columns in Excel?
Is there a way to collect separated group of columns in one formula, like here?
I want to skip the E column, and then apply the same format:
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)
...
4
votes
1
answer
18k
views
How to change a cells color depending on the value of the cell above it/before it for hundreds of lines
I have hundreds of lines with varying values (currency) and want the cell to change color depending on the value above it eg. Greater than = Green, Less than = Red = Equal to = Yellow. ie:
A1 is $100
...
3
votes
4
answers
14k
views
Excel - Overflow the text of a cell to an adjacent cell that contains a formula
I have a table filled with datas that comes from other tables. The formulas in the cells of my table are quite simple (reference to a cell in another worksheet).
In my table, I have "Title" rows (...
3
votes
1
answer
3k
views
Excel - Highlight Unique Values Across a Row, Apply to Multiple Rows
What I am trying to achieve is create a bare bones diff tool using Excel. I have multiple files, each containing one column of data, and I would like to paste each file into a single column in Excel. ...
3
votes
1
answer
1k
views
Excel Conditional Formatting cell's value that has number suffix, like 99th, 23rd, or 1st
So I am filling a cell with Blue, Green, Yellow, or Red based on a Percentile Rank that is returned, that is numbers like ( >=90th=Blue, >=60th=Green, >=30th=Yellow, <30th=Red )
Currently ...
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 ...
3
votes
1
answer
3k
views
How do I limit a conditional formatting rule only to rows in a *table*?
It drives me crazy that I don't know how to limit the range of a conditional formatting rule to the last row in a table I've created.
The rule I have created is supposed to turn all blank cells in ...
3
votes
2
answers
4k
views
Apply Conditional Formatting VBA to All workbook Sheets
I am very new to this, I am making conditional formatting to highlight numbers above the average of all values in a row.
I need to apply this formatting to all rows in all sheets in the workbook.
...
2
votes
1
answer
27k
views
How to format a cell to auto-highlight a date that is in the past
I am trying to find a way to auto-highlight a cell in a specific color if the date entered in the cell is in the past compared to today's date.
If today's date is 4/26 and I enter 4/23 into the cell,...
2
votes
3
answers
8k
views
How to format a date field based on whether the date has passed?
I am trying to create an Excel spreadsheet where, when I input a date:
if that date is within 30 days it will go yellow,
if the date has already gone then it goes red, and
if the date is more than 30 ...
2
votes
1
answer
38
views
Can I make a conditional design based on other cells (Excel)?
I'm trying to make this by Excel rules:
That any cell (in column B) that is near (beside) "1" (in A) will be red, and any cell near (beside) "2" will be green.
Is there a possible ...