All Questions
9
questions
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 $...
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 ...
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" ...
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 ...
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)
...
1
vote
1
answer
1k
views
Excel - How to Match duplicate rows, with a unique ID - from a cloned and consolidated version of the same sheet
I've been given ownership of a document to manage and it's a mess, I want to tidy it up, but have ventured out of my depth unfortunately :(
I have two sheets
Sheet A (many instances of rows with ...
1
vote
1
answer
620
views
How to combine data from two sheets and conditionally format rows based on sheet of origin
I have 3 sheets in Excel "Open", "New", "Combine"
"Open" Sheet (Old list)
Ticket ID | Priority | Department | Status
36009 | 1 | Finance | 01-Open
34781 ...
1
vote
1
answer
77
views
Determine if multiple cells in row do not exist in another selection?
I have two spreadsheets, an original and a modified, and I would like to determine if certain collections of cells in a given row in the modified do not exist in the original.
For example, if I have ...
0
votes
2
answers
2k
views
IF statement with multiple criteria and multiple possible results
I have a spreadsheet and I need a formula to give me one of three possible results (good, neutral, bad) based on data from two cells. MTD and YTD on budget would be good, MTD on budget & YTD below ...