grey

  1. L

    VBA conditional formatting and contents clearing

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

    Column Headers in Grey Section, how to bring back

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

    Conditional formatting

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

    Remove row shading

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

    Coloring column cells based on values

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

    Transparent Background Image Printing Grey and Text In Front of Image

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

    help me with coloring

    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?
  8. S

    CF not formatting all cells

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

    Sort and separate data based on certain criteria

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

    Excel Workbook is blocked and not active - strange problem

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

    Excel: Insert cut/copied rows or columns option greyed out

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

    menus have lost their color

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

    Can't select or delete rows!

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

    Deactivating Cells Dependant on Another Cells Value

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top