interior color index

  1. J

    Doubleclick to change cell color and text

    Ok so I'm completely new to excel (and coding in general) and I just can't get it to work. I managed to get this far, but it telly me an End If is missing. (And I'm sure a lot more is missing as well): Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If...
  2. A

    VBA If/Then/Else formatting problem

    Hello! I am pretty new to VBA, and I am not sure why my code is not working. I wanted to create a subroutine that changed the interior color of a range of cells to light red if the date in the cell is more than 90 older than TODAY() (to show which events are past-due), unless the cell is...
  3. U

    Unlock Cells Based On Interior Color

    Hi There, I have an excel sheet that currently locks all cells except for the ones that allow user entered/selected data (drop down list). I have it set up that if previous cell is blank interior color of that cell is black, if previous cell is not blank then interior color is white. What I am...
  4. AT--o

    Sub that takes the value of a function

    Hi. In excel 2007. My function takes its arguments from cells on the same row that it is inserted. I just copy it down. The problem is I need to change the Interior of this cell (the one containing the function) according to values that while taken from operations between the arguments are not...
  5. A

    Use cell fill (interior color index) as criteria in sumif or count if

    Hello, Is it possible to create a criteria based formula in excel 2003 that uses cel formatting as a criteria? (without the use of VBA) For example, i have a list of values which all have different cell fill colors. 1 (green cell fill) 3 (yellow cell fill) 5 (blue cell fill) 9 (green cell...

Watch MrExcel Video

This Week's Hot Topics

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
Top