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:
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.
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlBetween, _
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
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...
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...
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...
highlight new content
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"...
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...
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...