shaded

Hi All I have a sheet with a lot of data, and a macro set on a button which hides any rows where the colour is shaded dark grey in a particular column. I want to put on shading when the value in column A changes (like banding in a table),but only when the value changes and the rows are...

Hello, Long time lurker - thanks for all the great solutions and tips that I have harvested from this forum so far. My question is: Is it possible to use use the IF function to react to whether a cell is shaded, and shaded a certain colour? Context: I have a budget template document with...

I've looked and looked and can't seem to find the solution to my particular problem... I'm trying to apply shading to rows of data that are all from the same calendar month. In an UNFILTERED range, all data grouped by month would be shaded alternatively by month (JAN, MAR, MAY, JUL, SEP, NOV...

I am using the following formula to apply a fill color to every other line on a worksheet. =MOD(ROW(),2)=0 I am also trying to group rows to condense the sheet for a summary presentation. Problem is, when I group the rows the formatting does not adjust so I get numerous rows of shaded or non...

Hey Folks I am running the following code so all shaded cells have to be filled out otherwise it won't let me save the excel file and so far I have this but seems not to work as it only works on some cells and only if some of that particular cell are selected and it is because of the For...

I have two different colours to represent dayshift and nightshift. I allocate these coloured cells by inserting initials (2 x digits) into same shaded cell. I wanted the ability to count number of dayshifts/nightshifts in a range allocated to a particular initial. Can someone please give me some...

Given the Cell set in columns A to C, I want each of the first 5 rows to be shaded and the next 8 not to be (or shaded differently), and so on, alternating by date. <colgroup><col><col span="2"></colgroup><tbody> Date Start Finish 2/19/18 0730 0830 0830 0900 0900 0930 0930 1200...

Hi all, I am trying to make a spreadsheet easier to read, the sheet has many lines and varies in length. Column B will always have something in so this can be used to find the end of the data. I am trying to shade in from B to S then miss T and shade U, the shading needs to start from row 5...

Is there a way to copy the contents of a cell, including the cells colour, to a different excel spreadsheet (eg the cell contains the word YES and is shaded green)

My first task at hand is to check whether or not Column’s E thru K is shaded "yellow" or not based on conditional formatting formula used [E2<>O2] =$E$2:$K$1206. So in separate column, I’m using Column AB2 as starting point to check if E (is yellow), AC2 if F (yellow) and so forth to identify...

Firstly thanks for taking the time to read. I need assistance with a conditional formatting issue in that in Column AD I have a two decimal point number which I need to turn shaded yellow if the number is greater than 8 but less than 12 and if column AI has the text Non Member. Also to turn...