All Questions
161
questions
-1
votes
1
answer
2k
views
Add until a certain value is reached and return the content of another cell
So I have the given table.
The formula will be in B6. The problem look like this: first I need to test if B2 is >= than B5. If it is I need to return B1 (Week 1), else add B2+C2 and test if the ...
- 1
0
votes
0
answers
20
views
PivotTable Conditional Formatting
I'm having trouble to understand how to apply PivotTable Conditional Formatting.
Homepage have a pivottable and a 'Date' filter.
Dataset have columns like:
Provider | Date | OC Number | Invoice Nº | ...
0
votes
1
answer
124
views
Stopping Excel Conditional Formatting rules changing between tabs
So I have set up a worksheet for my job and it is spread out between 3 different excel tabs. I created a number of different Conditional Formatting Rules to set up all the sheets in the same way to ...
- 1
0
votes
0
answers
26
views
Possible to implement more code, so that highligted dates does'nt show until "in progress" is written
I am coordinating a large amount of production orders that are linked to thereown projects.
In the worksheet that I am working on I have created a calendar which
I have managed to highlight weekend ...
- 33
0
votes
1
answer
2k
views
How to highlight specific dates in an excel calendar based on start and end date?
I am coordinating a large amount of production orders that are linked to thereown projects. In the worksheet that I am working on I have created a calendar which I have managed to highlight weekend ...
- 33
0
votes
1
answer
1k
views
Conditional formatting based on selection from a dropdown list
I have a spreadsheet that is used as a sort of a schedule. Each person has their own ID number and the ID number is shown in a distinct cell. So if my ID is 41, I might see myself scheduled 9-12 on ...
- 3
0
votes
1
answer
1k
views
Highlight entire rows when values in a single column are unique (conditional formatting)
I have a spreadsheet with several columns of data and a couple thousand rows. Each row contains a product and each column contains details about that product.
Example:
Row #
Category ID
Item
Item ...
0
votes
1
answer
7k
views
How to conditionally format if not on list?
Every tip online about conditional formatting and a list is about highlighting cells that match on the list. How can I highlight cells that don't match (ignoring blank cells).
For example, a list of ...
- 5
0
votes
1
answer
93
views
How to setup conditional highlight between two cells:
Looking to understand how to highlight one cell in one column based on what a cell in a neighbor column says.
Column H, in my spreadsheet, displays a differing number of required hours to graduate and ...
- 1
1
vote
1
answer
2k
views
Change Color Based on Color Value Defined in Cell
I want to use conditional formatting to change the color of cell B1 to the color I have defined in cell A1 (using hex values or anything else that will work).
For example, if I have "#FF0000"...
- 13
0
votes
1
answer
494
views
Using conditional formatting to highlight cells that exceed the criteria below
I'm working on a spreadsheet that lists width of a product in cell A, and height of a product in cell B. I'm trying to apply conditional formatting to highlight these cells if they surpass the limits ...
- 3
1
vote
1
answer
467
views
Formulas - Conditional Formatting
I need the cells from Aug to Dec to be formatted automatically based on the "plan numbers" if actual numbers are higher (green); if lower (red)- I'm trying to set it up so when data comes (...
- 15
0
votes
1
answer
1k
views
Excel: Conditional Formatting - Two rules for one cell
I currently have conditional formatting set up to highlight a cell (E3) red when a payment is made after the due date. However, I have a "late fee paid" column. I want to add a rule where if ...
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 = ...
- 95
1
vote
1
answer
3k
views
How do I highlight cells in column A that match text in column B?
I'm looking for duplicates. I am trying to highlight all the cells in column A that match text in column B. Cells in column A can be repeated, but B will always have unique text in each cell.
