Okay, so whether this is done by VBA or the conditional formatting tool isn't important to me, either would be fine. But at the moment I'm adding each rule manually in the conditional formatting tool and I've got about 200 of these to do and I know an expert out there has an easy solution for...
I have a single column of cummulative stock market returns going up and down on a daily basis. I'd like to have an up arrow show in the cell in question if the previous value in the column was lower and vice versa.
By cummulative stock returns, I mean if A1 shows the returns for January...
Hi! I'm trying to apply some conditional formatting to an Excel worksheet with a macro (using VBA). Below are the conditions and subsequent actions I'm looking to execute:
hide all rows (in the entire active sheet) if the value of the cell in Column G ="BID", AND if the value of the...
I have this formula for conditional formatting:
It strikes through the text if the conditionals are met... but the scrolling of this sheet takes a nose dive the moment I use it. How can I correct this? Should it be done in VBA instead?
I have a situation where I am trying to list all conditional formatting rules that are in an entire workbook. In this forum I was able to find a thread that is over 3400 days old. Thread is titled "List all conditional formatting rules in a worksheet". In that thread, this is the VBA...
I have this formula for Conditional formatting =ROUND($D$3*$C7,)>D7 and what I want to do... If the formatting is applied to any cell in range D7:NE41, then I want to apply that same formatting to D45:NE79 - the issue is that if I add that second range to the "Applies to" section of the...
I really need your help.
I have an inventory in and out log. It logs date an asset was issued and date it was returned. I have everything in a drop down menu and i need the following. these assets are loaned out on a daily basis and returned on a daily basis. (Or supposed to be) there...
My data has many number wherein some values are between 0 and -1. I labeled all of them with conditional formatting. However, it took quite a long time to replace all of them by 0. Is there any solution that help me to finish this more efficiently? Thank you very much.
I asked a question similar to this the other day, but have changed my approach and wanted to get some input.
Based on the date ranges in the table below, is it possible to use conditional formatting, or VBA, to color cells a solid color. Even better, if possible, can I use a gradient...
I'm looking to find a way to highlight rows within this range (not entire row), based on the following two conditions:
If any date in column A is a weekend, then highlight that particular row and/or
If any cell value in Column B at min. contains the word "TEST" (doesn't have to match...
I've had issues with conditional formatting extending beyond the range it's defined for (for example, conditional formatting is defined for A3:G3, yet it also formats cells outside this range like A4). It seems to get triggered by the existence of conditional formatting in adjacent cells (but...
** Context **
I work in television advertising, where we have to make sure that none of our spots (ie. the times when our ads are showing) are playing on the same station (channel) within a 16 minute interval.
Each week, we copy all of the spots (often tens of thousands) that we have...
I currently have a list that looks like this (albeit much much much larger in reality):
I would like to create a slicer for column D (Height (CM)). However, my table is not a pivot table. Does anybody know how to do this? I read online that I have to go into the design tab and do it...
vba & code
I need to conditionally format a column based on the text in 2 other columns and am just wondering what the best way to reference the entire columns in my formula would be
Here is the code as it stands
=AND(A1="MARIA1",C1="PORTUGAL: Segunda Liga")
So if I wanted it to apply to all of A and...
I'm looking for assistance in setting up a macro to do the following.
1. Add a blank row in between each set of value from Column G.
Column G is named "Handler (Job)" and may have different values on different tabs. Let's say it comes looking like this -
First of all I would share my data but it contains personal information about patients so I will abstain. I will preface through: in my role I receive many reports containing patient data and there is a lot of manual leg work to go and tell where the fallouts are. In this specific spreadsheet we...
I've basically got a column of names. I want to highlight duplicates. Conditional formatting works well, but but many cells in the column = "?" as a place holder. Obviously this will get flagged as a duplicate as well, but I want to take any cells that = "?" out of the running. So, basically...
I have a a big dataset where I've used the conditional formating to color values that are grouped as:
The values are in percentage of the total in that specific dataset, so all values are somewhere between 0 and 1.
Above 20% : green traffic light
19,9% to 5% : yellow traffic light
My column C contains "Graduation Dates" and D contains Call Status (whether I have called). I want my conditional formatting to highlight my column C cells based on the following ideas:
No formatting if date is far out
Yellow for date is next week so I know I'll need to call soon
I have a sheet with various conditional formats, I have noticed sometimes when copying value only into the work sheet that sometimes the conditional formats work instantly and some times i have to click into the cell and click back out to get it to pop.
is there something I can do to get them...