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
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 ...
CommunityBot
- 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 ...
- 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 ...
- 2,320
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 ...
- 2,320
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 ...
- 7,360
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 ...
- 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 ...
- 130k
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 ...
- 1,898
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 ...
- 1
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 ...
- 1,525
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 ...
- 19.1k
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
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 ...
- 1