All Questions
Tagged with vba conditional-formatting
41
questions
0
votes
0
answers
9
views
Why isn't xlPasteFormat carrying conditional formatting to new workbook?
I"m trying to take a workbook with formulas for calculation and export it to a workbook that is value only. The use case is a scorecard for different items, so having the overall scores color ...
- 1
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 ...
- 23
0
votes
2
answers
1k
views
Excel VBA Function Not Detecting Cells Colored by Conditional Formatting
I have a few conditional formatting conditions on my excel sheet that fill in cells with different colors. I am trying to count the number of cells colored by my conditional formatting in excel so ...
- 1
0
votes
2
answers
205
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
228
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
0
votes
1
answer
149
views
Why is conditional formatting in an .xlsm not printing?
I have an xlsm workbook that colours cell backgrounds based on comparison to adjacent worksheets. The adjacency is always 1 to the left, irrespective of whether sheets are inserted or deleted. The ...
- 708
0
votes
1
answer
424
views
Macro to delete cells highlighted by conditional formatting?
I was looking for a way to automatically remove duplicates in a given range with a macro but all I could find : it's either remove duplicates from a list or remove duplicates from a cell.
I thought ...
- 3
1
vote
1
answer
648
views
How to highlight cells in Excel that end in a numeric value
I work at a library and I'm given a report to create an Outdated Stock Report/Shelf Lists that rely on an item's Publication Date. Unfortunately, because of the nature of serial publications, the ...
- 37
0
votes
0
answers
43
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 ...
- 1
0
votes
1
answer
1k
views
VBA Conditional Formatting syntax for xlUniqueValues
I am trying to highlight duplicates using conditional formatting under VBA.
If you look at Conditional formatting using VBA, one of the XlFormatConditionType (Type) for FormatConditions.Add is ...
0
votes
0
answers
98
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
0
answers
1k
views
Copy arrows from conditional formatting
I am looking for a way to copy the arrows of the conditional formatting icon set. I want the arrows to be static when copied because the data should be linked to a Word document. The conditional ...
- 11
0
votes
2
answers
6k
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 ...
- 59
1
vote
1
answer
70
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
-2
votes
2
answers
1k
views
VBA script to fill cells that contain any text string
I am trying to create a VBA script that will conditionally format a range of cells that contain any text string with a fill color of my choosing.
So far, I use an Excel conditional formatting rule to ...
- 4,361
-2
votes
1
answer
5k
views
VBA code not sorting dates properly (Excel)
I have a spreadsheet that tracks items and dates. Each item has a corresponding date associated with it:
Screenshot showing conditional formatting:
If the date is equal to or less than 100 days from ...
- 4,361
0
votes
1
answer
207
views
Apply conditional formatting to large number of text cells
I have a table that contains up to about 100 different text values and I want to color them according to the text so that you can visually see what cells have the same text (table!B2:DB100).
I have a ...
- 111
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
0
votes
1
answer
99
views
Excel, Return a color depending on two other cells text
I need to do an analysis in Excel and I would like to color a cell depending on the text of two other cells. I have to do it for a quite big table, therefore I need a way to not do it manually for ...
1
vote
1
answer
1k
views
Change color for specific number of cells by value set in other cell
I have an excel sheet with data of planned and pending projects. In column "I" it states number of weeks required for completion of the project. Each row has separate projects listed. Column "J" to "...
- 13
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
1
vote
1
answer
288
views
Excel - Min Value in a filtered range
So, I have a table where Date is stored in column C, and time is stored in column E.
My table runs from row 5 (though this is the headers, so data is in row 6 onwards) down to row 9989 (though this ...
- 183
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 ...
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.
...
- 31
1
vote
1
answer
309
views
Conditional formatting changes number format - or does it?
The setup
I have two conditional formatting rules that apply to a range of cells. The rules are:
=R1C1="something" -> have the number format be Number
=R1C1<>"something" -> have the number ...
0
votes
1
answer
230
views
Clearing a drop down input based off the value of another cell
I'm building a stock control system in excel.
Each item has the following:
Quantity in stock
Reorder level
Order stock?
Ordered?
The idea is that when quantity <= reorder level, the "Order ...
- 48
0
votes
1
answer
3k
views
Excel 2013 & VBA > Count number of conditional formatting rules on sheet
Excel has a limit of the number of conditional formatting rules a sheet can handle before it locks up and prevents any more from being added. This can become an issue in complex sheets where one or ...
- 554
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 ...
- 1
0
votes
1
answer
3k
views
How to color fill cells between range of dates
I'm trying to develop an Excel spreadsheet to manage staff holidays. The idea is that there is a "Calendar" spreadsheet showing which holidays everyone takes. Here is the screenshot:
I use ...
- 113
1
vote
1
answer
6k
views
MS Project Change Text Color in Row based on Status Field
I am looking to change the color of the text for an entire row based on what is indicated in the "Status" field.
I have searched other forums and have found solutions that are close, but nothing ...
- 17
0
votes
1
answer
1k
views
How do I insert thousands-separators without affecting significant figures in Excel?
I need to figure out how to add thousands separators to large spreadsheets without affecting the amount of significant figures or the dates that are also in the tables. I can't figure out how to use ...
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,
...
- 1
0
votes
2
answers
898
views
Custom formula for databars in Excel
How would one go about using a custom formula to determine the format conditions for databars?
Meaning, in Excel under "Conditional Formatting" there's a format called "Data Bars". However, you ...
- 101
1
vote
2
answers
2k
views
Highlight Cells with Red Text
I have a column of text in which some characters (not cells) are in red font. Is there any way to highlight the cells which contain red characters via conditional formatting? VBA solutions would be ...
- 518
1
vote
1
answer
3k
views
Excel VBA - Conditionally format a cell using 2-color scale based on 2 values (max/min) on other cells
I'm trying to write VBA codes to conditionally format (2-color scale) cell A1 based on its value that between is >= cell A2 and <= cell A3. I'm using cells A2 and A3 so I can change the specific ...
- 35
0
votes
1
answer
3k
views
How to format cells between two dates with a colour based on a value in vba?
(apologies if this question is difficult to understand, i'm unable to post an image)
I've tried finding a solution for this online but haven't had much luck.
Ideally, I want to use conditional ...
- 15
0
votes
1
answer
2k
views
VBA Macro to sort and apply conditional formating to a range of cells with dynamic number of rows
I have a range (the image below).
Please note that:
Range is generated by another application, so number of rows is ever changing, and is not formatted as an Excel 'table'
The number of columns, ...
- 1
5
votes
1
answer
4k
views
Excel: Dual graded color scales
Is it possible to do conditional formating for two graded color scales over the same cells?
For example I wish to conditionally format a cell such that its color is:
Green to Blue graded scale for ...
- 173
0
votes
1
answer
443
views
Format columns matching drop down value Excel 2003/VBA
I have a drop down in Excel to allow user to select a comparison bank. When a bank is selected for comparison all occurrences of that bank are highlighted in the tables below the drop down. Here is ...
- 1
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 ...
- 133