All Questions
36
questions
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 ...
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 ...
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
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 ...
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 ...
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
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 ...
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 = ...
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 ...
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 ...
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,
...
-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 ...
-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 ...
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 ...