I have a long list of numerical values in a column and I am trying to set up conditional formatting to highlight cells that contain specific values in blue. The values I am trying to apply this formatting to are the following:
200180, 200181, 200182, 200252, 200940, 200065
After doing some...
I am trying to write a script that will highlight the cell adjacent to the highlighted cell. Here is what I have come up with but throws an error:
Dim c As Range
For Each c In Columns("B")
If c.Interior.Color = Excel.XlRgbColor.rgbYellow Then
Hi, I have a very basic question about plotting data in Excel charts.
My data contains two columns representing date and quantity and a third column which contains categorical values (see sample data below). I need to create a simple column chart with date on x-axis and quantity on y-axis and...
I need to translate the following data validation rules to VBA:
Cell does not contain: no blanks format - as white
-- stop as true
=OR($J3="Pending - Please Elaborate in Notes")
Both of these formatting rules apply to $K2 through $K1048576
I'm trying to find a way to set a Conditional Format for Column A based on text or color of another cell range. More specifically, my target range is $A. If $B through $H is either grey (it would be grey based on other set Conditional Formats), or contains an "X", I want Column A to be...
Hello all, 1st post here so I will try and be as descriptive as possible. Appreciate any help!
I'm using Excel 2018 and I'm trying to get conditional formatting to show an arrow pointing up in green and an arrow pointing down in red. I do not want to fill the cell with color, I only want the...
I have a spreadsheet where in Column C the CELLs are filled with a mixture of text and numbers.
I am wanting he text to highlight in a colour when text is entered and the numbers to remain black.
Column C3 has Email typed - This would turn red.
Column C4 has a number - 1234 - This...
I would like to use conditional formatting to highlight cells that have an actual date and time after the originally scheduled date and time.
For example, column 4 row 3, the delivery time is 18 minutes late - I'd like to highlight that. And in row 4, it's a day late, that would also need to...
I'm wanting to make some dates within a spreadsheet change depending if the date is older than six months (turn red), is two weeks before the six month deadline (turn amber) or is within the six months (turn green).
I can get the dates to turn red and green but it is the formula for the...
I run a few golf pools a year and have a pretty good spreadsheet that automates a lot of stuff (now if only I could tie into alive leaderboard). One of the things people want to see is their lowest 7 scores highlighted. I can total the lowest 7 using the SMALL function, but when...
I am trying to assist someone with reconciling all of their business financial information into one excel workbook. It has become a little complicated now that I have worksheets for bank information, time keeping information, and multiple quick book exports. I have noticed that the check...
I have a sheet that has multiple lines of data and in many cases there are repeated lines because I am linking headers and lines.
A B C D E F
Contract Customer Name Contract Date Charge qty...
I am working with 3 columns and need the following things to happen:
1) If a cell in column F contains a date, the cell in column G should add 5 business days to this date (due date). Column G should be empty if there is no entry in column F.
2) If the date in column G has passed, the cell...
I have what I think should be very simple, but is not working for me right now!
I am working on a scorecard sheet. So, we have a number of metrics, and for each we have Target and Goal for every month. Then, for each metric, there is a calculation of the percentage-where are they in...
I'm using excel 2013.
How do I count the number of cells that have been conditionally formatted to be a certain color and output the result in another cell?
I have a spreadsheet full of stock picks.
All stocks are displayed in rows 5-50
Different analysts ratings are displayed in columns F thru...
The Background Fill portion of Conditional Formats has stopped working. Both the range and the formula are valid because the Bolding of the font and the Underline-ing of the rows work as expected. Only the colored fill is missing. For instance, the CF formula is =AND(MOD(ROW(),3)=0, $A1<>"")...
I am using the following website to try and count the coloured cells in workbook (including the code posted):
I have conditionally formatted my work, and I can see that it is working (all the cells I want...