All Questions
4
questions
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 ...
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 ...
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 ...
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 ...