color cell based on value

I have script that will look that will search for specific text within a cell in a specified column. If found, it will change the interior color for the row of the table. If not found, the script will loop to the next cell in the column until the last column is reached. This script is working...

Hello I have a time consuming problem. I make a lot of risk analyzes and depending on the probability and the consequence the risk is marked with Green, Yellow or Red. Now I change the colour manually but it would save a lot of time if the cell changed colour depending on the values in the...

I combine to cells into one using this command. I have two tables in the same structure. I use this command =a1&" "&A1 The first a1 is from table one the second a1 is from table two. The result is cell one 1 141 cell two 0 106 Whenever the first argument is >0 i want to color the cell...

Hi everyone, I could not find a solution for this. On Sheet 1 I have a table such as this: <colgroup><col><col></colgroup><tbody> Vehicle Car Colour Code Red Bicycle Blue Tricycle Yellow Motorcycle Yellow Train White Plane Green Boat Aqua </tbody> On Sheet 2 I have another...

I have set conditional formatting at both of my column BA and BB. The cells will be filled in color if the values are in the range. Columns("BA:BA").Select Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _ Formula1:="=0.921", Formula2:="=0.931"...

Is it possible to determine an argument if D2 is =< 50% of E2 to color format D2 and or column D?

Hello, I've done some researches but havent found what i'm looking for .. I'd like to highlight duplicate cells (Name and Surname) (case insensitive). But with only 2 colors (or perhaps more like 4) - Light green/yellow (otherwise the cell won't be readable when printed... Is it possible for...

Below is the worksheet setup for a worksheet (Dragdown) function I've created attempting to show a color range. My question is how do I perform a function where my worksheet cell colors change based on the (Select Case Statement) below tied to my current Work_Sheet Change /Set Performance MY...

Hi, I am trying to create a work book containing names of people with the color coded dates if that certain item is near expiry or is already expired. I have done that conditional formatting, however the data is too many for me to narrow down as to what has expired. Question: I created a new...

I'm using Excel10 & searched the KB & am unable to locate a simular situation... Column A Dept name Column B Actual fiscal YTD Hours Column C Estimated Hours for the year the goal is to create conditional formating on the actual values in the rows ofcolumn B if they meet the following...

Hi I want to write VB code for an excel SS that searches for fill color and then performs an action based on that. For instance, if the fill color is red, delete the cell or empty it I use this code for coloring my cells: With Sheet1.Range(Cells(xx, yy), Cells(xx + 1, yy)).Interior...

I have written code to change the color of a cell based on whether the value of the cell is positive/negative. I would also like to change the transparency of that color (so the color is less intense). Does anyone know a quick way to add this change to my code? Or could someone help me write the...

Hi! I would like to know if there's a way to make a cell change color depending on the value of another cell, i have minimum knowledge about conditional formatting but I'm guessing it can only be used to condition the cell with the value as as I'm trying to color a different cell than the one...

I am in need with some assistance with Excel. I am looking to do an inventory for mileage on fleet trucks I have on my construction site. I have basic knowledge of building a chart displaying all the vehicles the unit #'s and the mileage. What I was wondering is there a format I can use to...

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?

This macro is part of a spreadsheet that is used for weekly ordering. I need to be able to look up a SKU i.e.: 3LTX1.1a and then highlight it and subsequent columns orange. My code so far has that capability. Two problems though - more SKUs may be added or taken away from the spreadsheet so...

I have a spreadsheet and I want to color particular cells in a column with a new color - i.e. any new changes need to be highlighted. I know there's a way to do tracking changes in excel, but it just sticks a little flag almost invisibly in the corner of the cell. I want to be able to bring the...

I have a conditional formatting question regarding dates. Below are the two scenarios: If the values in column H have passed (e.g., 12/01/2012), fill the cell in red. I tried to do this with the Conditional Formatting under Highlight Cell Rules > A Date Occurring, but it didn't work for any of...

I have values in column H for a reorder point for print materials. In column O, I have the quantity on hand for said printed materials. I want to create a formula or some kind of conditional formatting that will do the following: If the quantity on hand is greater than the reorder point by...

Environment: I am using Excel 2003 and self taught in excel and VBA. I am very new to VBA and if pointed in the right direction will learn a topic. However I need direction I have a mockup of a Call Center floor seating diagram called "Seating Chart" Workbook and Spreadsheet. "Seating Chart"...