dark

Hi there, I have a question related to creating a macro in VBA (data and desired outcome below). I have a table in Excel, where in column A and H I have data. In column A there are classes and in the column H are students. I would like to have only one row for one class and currently I have...

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...

Hi, I am working on formula to help my staff on their data entry. We have the primary code in column A and we need to input color of each item in column B In column C, we then have this formula, =IF(A2<>A1,B2,IF(ISNUMBER(SEARCH(B2,C1)),C1,C1&","&B2)) it basically check if all these 3 input...

I know color code duplicates is a very common issue here on the internet, but I can't find any solution which is similar to my needs. Based on the value in column A("My data") I want to color code the whole row where the value is the same. I.e. row 1 and 2 has the same value and should be...

Hi Everyone, I have an excel sheet with a pivot table/slicer that is formatted with a dark border. However, when I use the slicer to drill down the cells that are now empty show no formatting. Is there a way that I can keep the dark border once I drill down? Regards, Dastnai

Hello Everybody. I work long hours on my laptop and I'm trying to customize a little the appearance of my PC. I'd like a DARK theme, but unfortunately, Windows 7 doesn't think I deserve it: I managed to get a dark theme (without aero) but this changes the "default colors" and excel became...

<tbody> Small Medium Large Blue 1 1 2 Red 1 Green 2 Orange 1 Purple 1 2 Yellow 2 1 1 </tbody> I have a worksheet that I need some help with. I need formulas to accomplish a count. Basically I have two columns outside of this range. One column is...