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