cell background color

  1. C

    Highlight/Fill Multiple cells based on one cells value.

    Hello Everyone, Basically I want to show how many people will be needed per station bassed on Cell O16's value. For example if O16 read 8, I would want cells D and E 5-12 to be highlighted. I'm sure this is a simple formula but I'm a neophyte at this. Thank you!
    • cbc818
    • Thread
    • cell background color cells fill formula highlight cell or row
    • Replies: 2
    • Forum: Excel Questions
  2. S

    Conditional Format using nested IF statement or VBA Macro

    Hope all is well, This is what i plan on doing, Cell A1 has the word Approved, and cell B1 has a Date, I want excel to do the following If someone enters the word Approved from a drop down in Cell A1 then highlight the cell RED If someone enters any date in cell B1 then cell A1 will have no...
    • sachin20us
    • Thread
    • cell background color color cell if conditional format macro vba
    • Replies: 1
    • Forum: Excel Questions
  3. S

    Select cells based on colour, copy and paste as values

    Hi Everyone, I am creating P&L's that pull out numbers on OLE functions from my finance system. The end users of the P&L's do not have the permissions for this and values must be copied and pasted to hard code them. I am looking for some code that will select multiple ranges of OLE cells, copy...
  4. B

    Formula Cell Color depending on Date

    Hello everybody, I have this Excel document i use at work, i have a cell with today's date (B4) on it and a table where i have a agenda like with the dates (AC2, AD2.. and so on) what i need is that if the cell (B4) is equal to today's date in the agenda(AC2 or AD2 or so on) it changes the...
    • balvy
    • Thread
    • cell background color excel & vba help formula excel work schedule
    • Replies: 1
    • Forum: Excel Questions
  5. J

    VLookup to Reference Background Color of A Cell on Another Worksheet

    Hello, I am using a VLookup formula to reference data on another tab. Some of the data that I would like to reference is only the color of the cell. Is it possible to use a VLookup to show the color of the cell on another tab? (There is no data in the cell - it is just the background color I...

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