gradient fill

  1. T

    Gradient Conditional formatting

    I would like to create Conditional formatting based on the text in each cell. Let's say that each cell contains a list of color names and cell background color should be some sort of gradient between them. Let's say cell A1 value is "blue, green" I want its color to be like in the photo below...
  2. C

    Coloring cells based on a date range

    Hey all, I asked a question similar to this the other day, but have changed my approach and wanted to get some input. Based on the date ranges in the table below, is it possible to use conditional formatting, or VBA, to color cells a solid color. Even better, if possible, can I use a gradient...
  3. D

    VBA Conditional Formatting with Gradient Fill

    Hi I'm trying to combine two sets of VBA but as I have very little expeience of dealing with VBA I don't know how. Basically I want to end up with what I described in the title. The First thing I'm wanting is to fill the cells background based on its Value, and based on what i've found...
  4. I

    Conditional Formatting Using Gradient Bars

    Hey everyone, thanks for your help with this question. I am working on a report for work and I am trying to give a simple visual to show how close a facility is to meeting their goal and thought I could use conditional formatting instead of adding an additional column to an already large data...
  5. A

    Adding Gradient to a Cell on Mac Excel 2011

    How do I add a two color gradient fill to a cell on a Mac Excel 2011? I can only figure out how to add it to a shape or a chart, but I need to add it to a single cell. Thank you!
  6. T

    Gradient fill macro

    Hi Guys, I am trying to use a VBA script to fill a shape with Green and Amber based on the value in the column D. 1) If the value is equal to 1 then the shape needs to be filled totally by green 2) If the value is closer to 0 then the shape needs to be filled by Amber The problem is point 1...
  7. G

    Create Conditional Formatting in VBA based on value AND formatting of a cell

    Hello Dear Members, This is my first post here, and I can not post attachments, so I try to explain clearly what am I after. I have a "data" sheet with a list of equipment. Each has a number (ID) in column A and a toolstatus in column B. Toolstatus can be selected from a data validation list...

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