color cell based on value

  1. T

    how to color a cell with two numbers

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

    VBA Conditional Formatting Colour Coded Custom List

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

    Conditional formatting

    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"...
  4. S

    Color Format one column from the percentage result of an adjacent column

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

    Highlight duplicates in two different colors (on a BIG list)

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

    VBA- Worksheet Public Function with a select case statement (Coloring cells per conditions)

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

    Newbie needing technical help!!

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

    Conditional cell color format

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

    searching by fill color

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

    Changing the color transparency of a cell

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

    Changing Cell Color based on value (Not same Cell)

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

    Need some assistance with Excel

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

    How can I fill certain cells with color depending on what info is inside?

    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?
  14. Z

    VBA question - color multiple cells using a macro

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

    Apply Conditional Formmating to highlight ONLY New Content on a Column

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

    Conditional Formatting: if date value (x) is greater/less then percentage (y) then the cell color changes

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

    Conditional Formatting: if value (x) is greater/less then percentage (y) then the cell color changes

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

    Color cells based on lookup values in a separate workbook

    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"...
  19. D

    Conditional Formatting not correctly coloring cell with SUM

    Hopefully there is and easy answer to this. I have formatted cells to show colors based on specific numbers: 1, 2, or 3 = red 4, 5, or 6 = yellow 7, 8, or 9 = green. All working fine. EXCEPT - one of the columns is a SUM of the other columns. And that SUM cell is NOT following my...
  20. A

    Help With Replicating VBA?

    I'm finishing up a pedigree database of sorts that I've been working on as a personal project, and I need a way to highlight duplicate values. I know conditional formatting can be used to identify duplicates, but I need each duplicated value to be a different color. The goal: I found a VBA...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top