All Questions
Tagged with vba conditional-formatting
41
questions
0
votes
0
answers
13
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
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
0
votes
1
answer
153
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
442
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
661
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
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 ...
- 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
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
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
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 ...
- 59
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
-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
208
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
105
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
294
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
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.
...
- 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
247
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