How can I highlight data based on another cell in the same row?
Ex. I only want to Select data in Column C only if Column B = Rm2
A B C D
1 Bob Rm1 x 0
2 Jack Rm1 x 0
3 Dean Rm2 n 0
4 John Rm2 n 0
5 Barb Rm3 x 0
I want to enter a unique ID into an input box which will tell which row that id is available and then it will again ask me which column the cell needs to be highlighted. Once i enter the data, it will then ask me what is the change in data (again via input box). i can then enter the change data and then it stops.
View 1 Replies View RelatedI have a macro that already works well but I need to make a change to it and I can't figure out how to do it.
I need so when the macro is run it will prompt the user for a date. After they enter the date it will highlight cells A:K on each row that data appers.
A little background for this. It is a schedule for a call centre which can show two to three weeks of schedules per agent. We rerun the macro each day to update break times and I would like it so it will highlight todays line.
I want to highlight A1 red if C1 is greater than 55. Is this possible?
View 3 Replies View RelatedFrom what I understand this is a simple process but since I am new to programming and I am in need of help. I am trying to write into one of my macros that as it is searching in the sheet if it finds CRL in column C and if it finds a value between -1 and 100,000 in column K, then it will highlight the entire row green.What can I do to add this into my macro?
View 14 Replies View RelatedI am seeking assistance with code for column H to be highlighted when I have a value of "Pending" or "Work In Progress" is present in column E?
View 3 Replies View RelatedI have a spreadsheet where if Cell A2 says "Deposit", Rows A2-E2 would be formatted with a Blue background.
I've tried conditional formatting, but I can't built it into a Macro (I can't make it run), and it only highlights the cell that has that value. I also tried having the spreadsheet filter down to only the values I want highlighted, then highlighting all cells and un-filtering the column- this didn't work either.
It would basically say :
If (any cell in Row A) has text = "Deposit" (it needs to be exact, it can't be "containing"), set cell with the word "Deposit" and 4 cells to the right as Blue (I'm not picky about the color).
Abc500
abc-500
bbb300
bbb250
cac100
cac-100
ddd200
ddd300
fff-500
I want to be able to highlight data in column B where amount is identical (ignore negative sign) only where data in column A is identical.
In this particular case it should highlight 500,-500 where data in column A = ABC & also 100,-100 where data in column A =CAC.
Looking to use conditional formatting to highlight a cell based on the value of another.
I.E. Highlight Cell B2 if Cell A3 is 4 or greater.
INVENTORY-TRACKER.xlsx
I have a attached an inventory spreadsheet that I use at work. The only active column that gets data entered into it, is column E "Qty (Pcs)". I enter quantities of inventory in this column.
In column B is the part numbers for product. The letters at the end of the part numbers are associated with certain colors that you can see in the small chart to the right of the report. H=Yellow, M=Blue, S=Green, V=Orange and P=Purple.
What I am trying to achieve is when I type a value in the Qty (Pcs) row. I would love for the entire row that contains data to highlight in the respective color based on what letter is at the end of the part number in column B.
Example - I type 100 in E2 and the entire row of data turns Orange because the V at the end of 13001 is associated with Orange.
How do I make a row highlight based on a given number in a cell...
For example my spreadsheet has a balance column...when the balance shows 0.00 for that line i would like it to hightlight gray
I need a macro to highlight a cell based on other cells.
For example:-
1. I wants to highlight A3 in red if all the cells from I3 to Y3 are empty.
2. I wants to highlight A3 in yellow if I3 is filled and J3 is empty
3. I wants to highlight A3 in green if if I3 is filled and J3 is also filled.
Actually I am having a grid which shows all the components of watch like KIt, case, dial , strap,hands.
The A row is purchase order no and then I3 and J3 belongs to KIt means if a po is not then I3 and J3 are empty so A3 is high Lighted in REd and if a po is placed then we put supplier name in I3 and it changes the color to yellow and when a po is confirmed we put confirmation date in J3 so A3 turns to green.
So in this way we can see if any Po is not yet placed or not yet confirmed based on cell color.
I want to track winning football teams by highlighting the victor. So lets say I have a cell that contains
Raiders @ Niners
and another cell containing "home" or "away" indicating the winner.
Based on the home/away cell, I want to either highlight Niners/Raiders.
Let's assume Cell A2, A3, A4, etc, only contain names/text.
Then let's assume I have set up cell B2, B3, B4, etc, to contain a percentage value based on a formula and some other entries I have made.
It should be simple, but I'm having trouble - how do I set up A2, A3, A4, etc, to highlight into different colours based on Column B's data/percentage falling into a certain range?
ie: - if B2 is between 0% - 25%, then highlight A2 green
- if B2 is between 26% - 50%, then highlight A2 orange
- if B2 is between 51% - 100%, then highlight A2 red
Not very good at this but I have the basic sheet attached. All I want is a way to highlight the first cell when the date is within 30 days of the "Due date".
Calibration Record-example.xls
I am trying to find a way to automatically highlight all the cells specified by the cell references in a column on another worksheet (which will constantly have new values added).
On the attached sample, the 'Data Before' tab shows the base data before any highlighting. As cell references are added to the 'References' tab in 'column A' I want the respective cell to be highlighted on the 'Data Before' tab resulting in the 'Data After' tab and each time a new cell reference is added to the 'References' tab, the respective cell is then highlighted on the 'Data Before' tab.
I would like to have control over the highlight colour so that a different highlight colour can be specified for each date change, i.e. all cell references that are shown on the same date are the same colour but where the date changes a different highlight colour can be specified.
Highlight by Cell Reference.xlsx‎
I need a macro that will highlight a row based on a cell criteria. I have used conditional formatting but there is a lot to format and has dramatically slowed the sheet down. However, I know nothing about macros/vbas.
E.g. If it states JI sent then I want the whole row to be highlighted light green.
App form needed = peach
Waiting list = light blue
Cancelled = red font strikethrough
DNA = purple font strikethrough.
Also - it could well be that in the row it has App form received, JI Sent and DNA all in 1 go. So ideally I would want that row to be highlighted light green with purple font strikethrough.
Booking Status
JI Status
Date JI Sent
Attendance
Cancellation date
Chargable / non chargable Cancellations
Chargeable / non chargeable DNA
Date taken
Time taken
Event Title
Start Date
Time
App form received
JI Sent
[Code] ......
I am trying to highlight a cell based on two randomly generated number, one is the column and the other is the row. Based on those values I want to change the color of a cell in a range of data. The formula I am using does not work like I intended. It only changes the cell once I enter a value in the cell not until. =OFFSET(A1,B27,B26). B26 and B27 are the cells housing the random numbers and A1 is the base reference.
View 1 Replies View RelatedI looked around at some date functions and could not find one to work.
I have a sheet that has 365 days. When I load the sheet I want to cell for today to be highlighted in some way..... color or just active.
If date = 05-10-2007 then
BackgroundColor = 17
else
BackgroundColor = 9
end if
I want to highlight an entire column based on whether a cell in that column is equal to today's date.
I know how to write a loop that cycles through all of the columns until it finds today's date and then modify the column's properties, I was wondering if there was an easier way to do it. Also, I want the highlighting to be temporary meaning it should not save.
I'm having a difficult time making this work properly.
To simplify, I want:
cell A1 to fill with blue when cell G1=0 or greater.
cell A1 to fill with yellow when G1<0
Next step is to apply this to cells A1:A100 based upon cells G1:G100.
I have created a drop down box that allows me to choose multiple different Text Options. Example: Cell B4 has dropdown that lets me choose the Text Options, "House", "Car" and "Truck".
Next, I have 5 or so other columns underneath with their own text. What I want to do is have different cells highlight themselves depending on what is in Cell B4.
Example, if "House" is selected in B4, I want cells B7 and B9 to highlight. If "Car" is selected, I want cells B7, B8, and B10 to highlight. If "Truck" is highlighted, I want cells B9-B11 to highlight. Is this possible to do? I've tried using If/Then statements, but those don't seem to work for this type of thing.
I'm having issues with Excel's 2010 conditional formatting. Seems easy to use, but I'm trying to highlight values based on 2 columns of numerical data. Example:
Column F:
6
6
14
Column L:
3
NA
17
I would like Column L to highlight values that are greater than Column F in green. If they are less than Column L then highlight them in red.
Seems I was able to do this with Excel 2003, but I don't understand the 2010 version.
MS Excel 2010, WinsXP
how to highlight an entire record based on the value of a single cell?
I would like to highlight all records grey where cells in a column = "closed".
I have been wracking my brain around how to put this formula together.
Is it possible or it can't do more then 1 cell at a time?
Here is an example:
If F1= button request and E1= Scoring then OK (take no action) also i want to add that Folder in F and Corrupt in E would = OK
If it doesn't match to highlight the cell in red
I could not find an easy solution to the find/remove duplicates in a row from left to right.
I have an other option: sort all data in one row, then it will show me, if there are any cells with the same word.
But .. here is my first problem:
First row is A1: AS1 with data.
A2: BB2 with data
A3: BD3 with data
A4: BX4 with data and so on.
When I start at A1 and press Shift/CTRL/Arrow right, it will hilite the row until BX1 and if I use the sort command, it will place all empty cells in front of the data.
What I need is hilite only up to the last column in that row.
So I could slowly work myself downward. Or prehaps there is a formula?
I could insert an empty space and write the formula in A1 and copy it down to A1644.
I have a spreadsheet with over 6k rows, each with over 30 columns.
My focus is in 2 columns. ColumnA is formatted as General, ColumnB as Number.
ColumnA
ColumnB
05255088-0f15-48f1-a65e-affb6d583d35
1373064224475
05255088-0f15-48f1-a65e-affb6d583d35
1373064224475
[Code] ........
I need VBA code that will Fill the cell in ColumnB if it changes within the same ColumnA data.
So the output would end up like this. (Although the cell would be filled, not the text turned red)
05255088-0f15-48f1-a65e-affb6d583d35
1373064224475
05255088-0f15-48f1-a65e-affb6d583d35
1373064224475
[Code] .........
So it's pretty basic. If we simply remember the first ColumnA and ColumnB data, go to the next row, if ColumnA is the same, then ColumnB should be the same. If it's not, then fill with red, go to the next row, repeat. if ColumnA changes, remember the new pair, go to the next row and compare again.
I've thought about this from a scripting perspective, and imagine that something like this would do the job:
Code:
sub FindBadTermID ()
Dim row As Integer
Dim dataA as string, dataB as string
Set row = 2
newColumnALoop
[Code] .......
i am going to be making other columns with data. i want it to highlight the cell from the new columns if the value is higher than the standard.
not quite sure how to do this? do i make an if statement and put it in the cell, then go and input my data over it?
I have a spreadsheet where I have a column of dates and I want conditional formatting to highlight the cell red if the date is less than or equal to today but if the cell is blank to do nothing.
At the moment I have the following formatting applied using the "format only cells that contain" option I have cell value less than or equal to =TODAY() except that obviously highlights every cell red that doesn't contain a date. Is there another conditional format I can apply in addition to this that will not highlight the blank cells ?
I have a worksheet with 20+ columns. For this macro, I only need to focus on 4 of them. However, none of these columns are ever in a fixed position so the macro would need to find them by name and NOT by column position. Here they are...
1. Vacation Type (will only have a text value of either "Cold" or "Warm")
2. Vacation Started (will always have a date *x/xx/xxxx)
3. Vacation Ended (sometimes it will have a date '*x/xx/xxxx' and sometimes it will NOT have a date and will be truly blank)
4. Number of Days (currently has ALL truly blank cells)
THIS WHOLE MACRO SHOULD NOT BE CASE SENSITIVE ANYWHERE
Here's what I would like the macro to do...
Scenario 1 - for "Cold" values Find "Cold" text values in the "Vacation Type" column
"Cold" values WITH a date in the "Vacation Ended" columnIF there IS a date in the "Vacation Ended" column in the same row, put the number of days difference between the "Vacation Started" column and "Vacation Ended" column in the "Number of Days" column.
The amount of days in the "Number of Days" column will determine whether these cells should be highlighted GREY or RED.
Scenario 1-AIF the number of days difference is 7 days or less, highlight the cells in the "Vacation Ended" column and "Number of Days" column RED.
OR…
Scenario 1-BIF the number of days difference is MORE than 7 days, highlight the cells in the "Vacation Ended" column and "Number of Days" column GREY..................................