.interior.color

Hi All, I currently have the following code which provides a R/A/G rating dependent on a cell value. This works as expected however I'd like to amend this so that if the cell value is 0, and the previous value is also 0, then it shows as Green, rather than Amber. The cell value in question is...

I have an issue with the formatting of data. the script I have copies data from "PASTEDAT" tab and paste into "QUASAR Script" tab. So the data from the "Data"tab can be as follows 546882 546883 '092384 Copying the 546XXX numbers are ok. However, the resultant for the last number pastes into...

I am using the following code to loop through all rows in the designated columns in the ColourColumns array and color the cells depending on their value with a select case statement. I would like to loop with 40 rows i 1 column F, then the next 40 rows in the same column and compare the values...

my spreadsheet has data in Coluns A thru E and j Thru R in F, G and H I have the RGB values and I want to colour column I Usng the follwing code I am able to colour the cells but the macro throws a Run-Time error '13': type mismatch and hightlights .Interior.Color = RGB(.Offset(, -3).Value...

I'm trying to modify the code found in this thread for a workbook I have. I've added the formulas that suit my conditional formatting requirements, but I need help/education with applying the rules to each row on the worksheet (2-31) and also modifying the sheet name(red lettering) reference in...

Hello, I have this piece of code that I am using to format a worksheet to later be used as a comparison template for another worksheet. Sub Comparison_Formatting() Dim LR As Long, _ i As Long LR = Sheets(1).Range("A" & Rows.Count).End(xlUp).Row With Application .ScreenUpdating =...