All Questions
9
questions
2
votes
1
answer
50
views
Separately color all rows for unique clients listed in one column
I am a relative Excel noob, and to that end, forget about Excel macros. I'm here because this seems to be where the GOATs congregate, and I really need some help.
I have an enormous data set that ...
0
votes
0
answers
47
views
how to compare 2 columns and if the value in A is higher than B, copy the value of A over B
I'm trying to compare 2 columns of similar data and would appriciate some help. i need to know how to do the following. I what to know how to compare the values in column A with column B, then if the ...
0
votes
0
answers
100
views
Macro validation and conditional check
i have below excel where i want to do data validation for ColumnName1 ColumnName2 ColumnName3 & ColumnName4 and as well check the condition if ColumnName6 = ColumnName7 && ColumnName5 = ...
0
votes
2
answers
7k
views
Changing font colour in a cell with a formula
I have a spreadsheet that is used by a group of people. Its purpose is for service admin to plan runs for service techs weekly.
They input each job and a travel & task estimated time in minutes ...
0
votes
0
answers
241
views
Excel update cell when cell above is hidden by filter
I have a sheet with events - and a column with the weekday of the event
Some days have both 3 and 4 events
So, in column P, I filter out the duplicate days
As you can see, I have a filter on Q. If I ...
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.
...
0
votes
1
answer
133
views
Conditional formatting on conditional formatting
I have a spreadsheet, and there are various drop-down menus on it to select various criteria.
When certain criteria is selected then data in different cells show up in various colours. I have used ...
0
votes
1
answer
2k
views
Formula or VBA for cell formatting using value based on a cell but formatting from an other cell
I have a fixed set of values, (0%,20%,40%,60%,80% and 100%) in column E.
If I fill a cell in column E with any of the above values, the cell G should pick formatting from another cell.
For example,
...
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 ...