All Questions
Tagged with microsoft-excel-2016 conditional-formatting
45
questions
1
vote
1
answer
69
views
Coloring cells across multiple excel sheets in an xls file based on a condition
I am new to excel. I have an xls file with 10 sheets. In each sheet I have two tables of size 10 x 10, one starting at position A4 and the other starting at N4. All the entries are numbers.
(Note that ...
- 113
0
votes
1
answer
108
views
Microsoft Excel Conditional Formatting for Dates and Prices
I'm looking to conditionally format a table following this general idea; I have short dates in one column and years in the headers for several other columns, Id like to highlight the cell when the ...
- 1
-1
votes
1
answer
86
views
Highlight rows when all values are for Order Number
I have a spreadsheet with two columns. One column is Order Number and the other one shows its status. As shown in the screenshot below:
Sample Data Sheet:
I want to highlight all the rows when the ...
0
votes
1
answer
122
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
3
answers
7k
views
Why is my conditional formatting not working?
I have a column of consecutive dates. I would like to highlight the rows for Saturdays. I have Conditional Formatting applied to $2:$112, and the formula for formatting is =weekday($a2) = 7. However, ...
- 13
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
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
167
views
#VALUE! error using excel 2016 nested IF statements
I'm unable to perform a simple nested IF statement on this data, the conditional seems perfect to me so it must be a formatting error or something else. I'm new to excel so I could be wrong.
This is ...
0
votes
1
answer
2k
views
Excel - automatically updating cell reference when applying conditional formatting to range
My question concerns conditional formatting in Excel. Here is a summary of my situation:
I have conditional formatting set up for a particular row in Sheet A. The formatting formula checks whether ...
- 1
0
votes
1
answer
208
views
EXCEL - How can I use conditional formatting to color code if this week's value has increased by more than 5% from the previous week's value?
I'm tracking the increase or decrease of the percentage total of risks that are classified as being caused by something specific (the Business, IT, legal, Organisation, Security, etc) from report to ...
1
vote
1
answer
654
views
In Excel, how can I highlight two cells based on a condition of either cell?
How can I highlight two cells based on a condition of either cell? Given two rows of data "PCT CHG" and "WEEK", I would like to highlight both cells if the value in "PCT_CHG&...
0
votes
1
answer
49
views
How do I conditionally format to highlight cells with =-IF in the formula?
I have a large workbook with many sheets, each with two sections in them.
One section, the formulas should begin
=IF(ISNA(...
and in the other section the formulas should begin
=-IF(ISNA(...
...
0
votes
2
answers
277
views
Complex Conditional Formatting
I'm a CPA with lots of Excel experience, but can't seem to figure out an answer to this question (of my own). Is there a way to apply conditional formatting for the below example:
EXAMPLE: I have a ...
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
0
votes
2
answers
127
views
Excel 2016 - Apply Conditional Formatting based on value of a prefix label
Hi I am trying to apply conditional formatting using the following search function: -
=ISNUMBER(SEARCH("S",$C1))=TRUE
My problem is that the "S" has been applied using custom format to insert the ...
0
votes
1
answer
4k
views
Inserting rows without moving the conditional formatting
I'm working on a spreadsheet with a lot of conditional formatting.
But I've got one thing that I'd like to change but isn't working as wanted.
I'd like to highlight an individual row ( lets say Row ...
- 1
0
votes
1
answer
145
views
Mass conditional formatting
My goal: I am trying to create an automated schedule using conditional formatting that, once a block of time has been assigned, will color code itself. The best and the only way I could figure how to ...
1
vote
2
answers
3k
views
Conditional formatting for merged cells
I have these two rules for a set of cells:
The full formulas are
=$AB27=""
and
=LOWER($AB27)=ok
I thought this would make it so that if "ok" (with any capitalization) was entered into the the ...
- 958
0
votes
0
answers
95
views
Conditional Formatting Wont Work
I created 4 conditional formatting rules and for some reason, only 3 of them work.
For all 4 of them, the rule type is set to "use a formula to determine which cells to format", as I want the whole ...
- 11
0
votes
2
answers
174
views
Conditional formatting on 4th entry?
I know how to change the cell color for a duplicated entry, but how/can I change the color on every 4th entry? Value will be an unknown number & letter combo, wanting to highlight every 4th time ...
- 1
1
vote
2
answers
8k
views
Conditional formatting based on date difference
I need help with making the row or at least the cell turn red when it has been >20 days since the date that was entered in the cell.
For instance: I issue an item to John on 10/01/2018 and so I place ...
- 11
4
votes
2
answers
8k
views
How can I modify the "Applies To" property of a Cell's Conditional Formatting rule using VBA?
I'm attempting to use VBA to create a conditional formatting rule and apply it to multiple cells.
I've attempted this is by creating the rules for one cell only and then editing the appliesto ...
- 347
0
votes
1
answer
4k
views
How to color only numbers and special characters in a Microsoft Excel cell
Is it possible to color only numbers and special characters of a cell (or column) by conditional formatting or some other similar method?
I have created a book in Excel to organize my passwords (or ...
- 103
1
vote
1
answer
2k
views
Excel: count number of conditionally formatted rows
I have an excel sheet in which I apply conditional formatting on two columns. The row is only highlighted if the cells in that row meet the condition. Specifically, I want to highlight rows where the ...
- 11
0
votes
2
answers
163
views
How to identify the original cell location that contains the Max information that my formula gives me?
What I am trying to accomplish is to Identify the Max of B1:B60, B60:B120, B120:B180 and so on throughout the entire column. I would also like to identify the location of those cells, and (ideally) ...
0
votes
1
answer
909
views
Excel. Data Bar Fill background Part of bar
Is there a way to in Excel 2016 to fill the background part of a data bar. not the progress bit the other part so for 25% 1/4 will be red and the other 3/4 will be green.
OR is there a way to make ...
0
votes
2
answers
873
views
Change the formatting of a cell depending on the value of that cell and another cell
EDIT:
Okay. Thanks to BruceWayne, I have made progress.
However, the formula I ended up with:
=AND($C3="Y",OR($G3<=0.5,$H3<=0.5,$I3<=0.5,$J3<=0.5,$K3<=0.5,$L3<=0.5,$M3<=0.5,$...
- 23
5
votes
2
answers
7k
views
Conditional Formatting: Min Value Across Multiple Columns in Excel
I have three columns--Order, Buy, and Craft--and want to identify the minimum value for the row. In the image below, I identify the value in an additional column. I want to avoid the need for the ...
- 63
1
vote
1
answer
2k
views
Conditional Formatting using average function in Google Sheets/Excel
I am trying to figure out how to conditionally format a particular cell depending on the average value of a number of other cells. So I've tried a variety of solutions all either ERROR-ing or not ...
- 13
0
votes
1
answer
24k
views
Conditional Formatting when between two values
I am trying to figure out how to conditionally format a row based on the value in one column. The values can go from 0 - 100, I want 3 different conditions.
value < 90 = Formatting Red
value => 90 ...
- 159
0
votes
2
answers
2k
views
Whats wrong with my Excel conditional formatting?
I'm trying to mark a column's data with a red background if the values in it are outside of a 15% threshold. For this I'm trying to use the formula:
=(ABS(($D:$D-$E:$E)/$E:$E))>0.15
However, it ...
- 197
1
vote
2
answers
2k
views
How to copy conditional formulas across sections of a worksheet?
I have data laid out within mini tables within a singular worksheet. See picture
I need to conditionally format the whole row (within the minitable) based on a cell value within the row.
For example, ...
- 11
0
votes
2
answers
2k
views
Highlight cells cumulatively based on less than or equal to value in specific cell
I feel this is possible, but I have been unable to get anything working using conditional formatting and am not quite sure what direction to take in VBA.
I want to highlight cells across a row,N2 ...
user860542
4
votes
1
answer
11k
views
How to apply the same conditional formatting to other cells?
My spreadsheet has multiple rows. Each row has a checkbox. If a checkbox is ticked, conditional formatting will highlight that row. I am curious to know if there's a way to apply the conditional ...
- 41
1
vote
1
answer
2k
views
Excel 2016 conditional formatting is not working with AND [duplicate]
I am trying to color rows automatically where a given condition is true, using conditional formatting.
For example, color the row if there is something in its D column: =INDIRECT("D"&ROW())<>...
- 123
0
votes
1
answer
1k
views
Conditional formatting based on frequency in column and value of adjacent cell (for each previous entry)
I'm trying to format a column (T) where names are entered using a data validation drop-down list.
Each name is assigned to a project so in the previous column (S) I have used conditional formatting to ...
0
votes
1
answer
338
views
Use a cell as a 'template' for conditional formatting
Maybe I'm being stupid and missing a trick, but I am looking to create an example excel file for conditional formatting.
I am happy with conditional format rule making, however I am having an issue ...
- 111
1
vote
0
answers
97
views
Conditional formatting in Excel: Referencing entire table column [duplicate]
In Excel I am trying to apply conditional formatting to an entire table column (it should be automatically applied, when new rows are added into the table)
However, the conditional formatting rules ...
- 91
0
votes
0
answers
235
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 ...
1
vote
1
answer
691
views
Excel - Conditional Formatting: Why can't I format decimal rounding? Only Font, Border, Fill?
In another post that is asking the same question that I ultimately have, the top answer says to conditionally format the cells using the formula ###,###. But when I go into conditional formatting, my ...
- 135
1
vote
0
answers
50
views
MS Excel 2016 conditional formatting
I would like to do conditional formatting on one cell based on different conditions of five other cells.
If the value in cell D1 is lower or equal to either cell N1, O1, or P1 etc. then cell D1 needs ...
- 11
1
vote
2
answers
4k
views
Conditional formatting so that each row highlights duplicated values
I have a spreadsheet with approx 300 rows. Each row has about 4 columns, and each cell contains a numeric value. Each row corresponds to a respondent.
I want to get Excel, for each respondent, to ...
0
votes
1
answer
657
views
Conditional formatting in Excel combining 2 rules?
I want to format my dataset (22x12 values) with the 3 color rule, but based on the values of another dataset so that the color can be used as additional information.
Here my example. I want to ...
- 9
1
vote
2
answers
3k
views
Cannot use Conditional Formatting in Workbook
The problem is simple enough to state. When I select a range of cells (as numeric values or indeed as values calculated from a formula), I cannot conditionally format them. What I want to do is to ...
- 258
0
votes
0
answers
991
views
Getting Excel to Conditionally Copy Data to Another Sheet
I have a spread sheet that will have new data entries on each row. I need to get excel to automatically check for a specific column's value, and if that value is a 1, it needs to go to the sheet with ...
- 1