color fill

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

I need to conditionally format a cell based on the value of another cell which contains a formula. I have columns headed as follows: Goods Pack Size Shop 1 price/100g Shop 2 price/100g Shop 3 price/100g Cheapest price apples 1kg 2.50 =2.5/10 4.20...

I want to color fill the name "Billy" in cell 1A automatically only after cell 1C, 1D, 1E is fill with a symbol check mark. Thank you, William

Hello, I want to color fill rows in a pivot table if the cells are <> 0. I know i can use conditional formatting to do this but i need to be able to copy and paste the data into a different worksheet with the colors still intact. Does anyone have some code that could help me?

Good Morning, And thank you in advance for your responses!! I have a question, that has been challenging me for past couple of days, and I would like to know if it is possible. In Excel, I am creating an 2-D Area graph out of 3 Tables in a same sheet. Now, each Table has few rows, and each...

I would like to automatically fill a row with a certain color based on a letter entry in the first column. EX: A in first column would automatically turn row to yellow; G in first column would automatically turn row to green, etc. Is this possible?

I need to look up a range (BE4:BE2383) and if the cells read "Pass" I want it Green if the cells read "Fail" I want it Red. How can I automate this?

I am running a production on 3 stages at the NAB tradeshow in Las Vegas. I have created a schedule of the performances. I want to have the cells change color as time passes. 5 minutes before the scheduled performance time, I want the cell to go from white to yellow. At the start of the...

I want to change the color of a cell based on the result of it need a negative to be in different color like cell h5=345.54 = yellow cell fill but cell h5 = -1253.50= yellow dark cell fill can someone help Z

Hi, im pretty new to vba and im trying to write a macro that will allow me to 1. get the mean average of numbers in a range 2. then colour fill the range depending on what the mean average is so far ive managed to write in out in principal i was wandering if any one could guide me in the...