grey

Hi all, May I please seek you hep with two VBA codes? I would like to highlight grey (rgbLightGrey if possible) row range A2:AI2 if value of R2 < 0 and repeat this for every row in the table range A2:AI232. Then, I'd like to delete content of cell (text & formulas) in range T2:AI2 if the...

I have a data table and when I went into it today the column headers are in the grey part where the columns letters are normally. How do I fix this? I have a feeling it has to do with freezing the top row for scrolling but, when I unfreeze it doesn't correct it. Thanks

Hello. I want to make a table that autoamticly changes the row's background color/text color every time the text from the first column changes. It should look like this: <tbody> aaa row bg color/text color: grey aaa row bg color/text color: grey 555 row bg color/text color: red...

Hello, Can anyone help me tweak the code below? I am using this code to insert a row beneath the header once it finds "Audit_Name". The code works and it does insert the blank row. However, since the header is shaded blue, I need the new row to be in grey (RGB 217,217,217) OR White...

Hi team, I need a macro that fill or not fill color (grey) to the cells of two adjacent columns based on change in values of the second column. Please see the example below. Here both cells in a row are either filled or not filled(including the numbered one). <tbody> grey color 1 grey color...

Hello, I have two questions for a cover sheet I am attempting to create. I have a template for a cover sheet I'd like to start using but am running into two errors. Background: I have inserted a shape the size I want the background image to appear. Then I went into the shape options --> fill...

I have FEW TABELS in my sheet except this boxes i need rest for the cells need to be Grey color (if cells have value it should be not change) is it possible?

I'm using a CF to format cells based on two values and it only formats one cell. It's applied to all cells to be changed and is only filling H7. Rule: =MATCH(H8,V4,0) Format: Grey Fill Applies to: =$H$7:$J$35 Not sure if I'm going about this the hard way or not, but matching Day in row 8...

Hello i'm trying to group the CODE values and get a total of the count based on certain instances. i cant use a pivot table when doing this so VBA code is preferred Then i would like to do the same but for "Coconut" only in the FRUIT2 Column using certain instances Then i would like to know...

Welcome All, I have very strange problem while working in Excel. It is hard to define so I was not able to find anything about in in search. It is also hard to define when it exactly happens, but the problem is following: While working on more than 1 Excel Workbook from time to time everything...

I'm using Excel 2010 and when I right-click on a row or column, the Insert/Insert cut/copied rows/columns context specific options are greyed out. The options work when I open excel in safe mode. This happens in all workbooks, including brand new ones. I've looked through the Excel Options...

the background color of my menus has changed to white, instead of the default grey. How do I restore the grey? I have removed all macros and add-ins and it did not help, If I start excel in safe mode everything is as it should be (right colors), but starting it any other way and the menu color...

Please help! My spreadsheet is working great except for this: suddenly I have two rows at the top that are grey. I can't select them to delete them and I want them gone! What do I do? Shelly

Hi, Basically I've been told to make a sheet completely idiot proof, so that data can be put into it without the ability to make mistakes. The Questionairre has questions such as if yes go to question 6, if no go to question 8. Therefore I want to make it so say for question 5, the answer...