All Questions
30
questions
0
votes
1
answer
31
views
How to use conditional formatting based on a different column?
Looking to format a column background color using conditional formatting based on the integer value from a different column. Where or how is the second column referenced?
Bing AI, copilot, says:
...
- 5
1
vote
1
answer
66
views
Excel conditional formatting highlighting different cells in range
I need to setup conditional formatting to highlight any cells in the range that are not equal to the first cell. I have attached 2 pictures the first is how the data is typically entered and I have ...
1
vote
1
answer
908
views
How to remove values in conditional formatting
I have conditional formatting rules applied to a workbook. When a user selects No in Row 1 for example, Row 2 and subsequent rows get greyed out. When user selects Yes in Row 1, Row 2 and subsequent ...
- 11
0
votes
1
answer
67
views
Excel - status (online/offline) corresponding to concrete number
I cannot deal with the below tasks, and need your help!
The thing is that I need to use a formula to solve this (not just copy-paste, assuming that the data will be much bigger). Basically, I need to ...
-1
votes
2
answers
795
views
How to copy/paste cells from a conditionally formatted sheet to another file or sheet with formatting but without conditional rules?
I have an excel file "Book1" with conditional formatting enabled on "Sheet1".
Conditional rules are based on a formula.
For example, highlight the entire row blue if the value in ...
- 183
0
votes
2
answers
217
views
How do I format a target cell based on a source cell, using VBA?
I'm looking to copy the format of a cell within the table table1 to cells with matching text within the second table table2.
So for instance: NOT(H) is showing as green in table 1 and I want it to ...
- 1
1
vote
0
answers
243
views
Excel VBA Macro: Formatting Duplicates and Uniques
I have a spread sheet where each row consists of information about a member of a group. In each cell of column B there is an integer that represents each person (i.e., think of an member ID). All ...
- 11
-2
votes
1
answer
48
views
How to use conditional formatting in excel for a crosstabbed table with multiple conditions?
I am having trouble in excel using conditional formatting for my table. I need to highlight the sample values that are greater than screening_1 or screening_2 for each individual row.If the value is ...
- 1
0
votes
1
answer
2k
views
Conditionally formatting left align for a cell with text thats separated by multiple lines
I'm trying to write conditional formatting that will handle left aligning text in a cell that is normally in a range that's centered. The data in the cell could look like the following with each line ...
- 123
0
votes
1
answer
80
views
Formatting whole and decimalised numbers differently in Excel
I'm having some difficulty formatting some data correctly and after looking around extensively in similar threads such as here, I've come looking for help.
I have two similar datasets (X and Y) and ...
- 1
0
votes
1
answer
49
views
How do i make different words (in column A1, A25, A37) automatically show a value (in column B1, B25, B37)
Can someone please explain how to do this with different words:
I have two columns (A&B) and about 40 rows in excel. I want to put in different words, say - Paper in A1, Chair in A2, Glass in A3,...
- 1
0
votes
1
answer
182
views
Why does conditional formating "white out" only certain manual formating is some cells?
I'm trying to make a spreadsheet with tables, with some automation, that keeps track of my work hours. (Note I'm not using the Excel "format as table" feature. This is all by hand). ...
- 139
0
votes
3
answers
13k
views
Excel Conditional Decimal Formatting
I am trying to have decimal places display based on the value inside a given cell. I more or less understand how to custom rules work, and have come up with this rule: [>=10]#,##0.0;[<10]0.00
It ...
- 3
0
votes
1
answer
55
views
Can I use conditional formatting in an Excel PivotTable to format cells based on specific fields?
I have the results of numerous tests run on several sub-samples. Many sub-samples make up a sample. Between 5 and 10 samples make up a lot, and I have five lots I'm trying to analyze.
Each one of ...
- 151
1
vote
1
answer
71
views
How to make dependent cells follow decimal formatting of parent cell that changes from time to time?
I need dependent cells in an Excel worksheet to follow the decimal formatting of a parent cell. I've done this with format painter, but my parent cell decimal requirements change from time to time,
...
- 11