All Questions
Tagged with vba conditional-formatting
41
questions
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 ...
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 ...
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 ...
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.
...
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
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 "...
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 ...
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 ...
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
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 ...
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 ...
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,
...
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 ...
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 ...
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 ...