I have a program that compiles a whole bunch of annual data.
The data is in columns A:J
I would like to have a program that loops through column A's entries and if the entries are odd then have the cells in Columns A through J of that row be highlighted with colour index RGB (193, 205, 205).
This is what I have below, but it is not working.
[Code] .....
I have made a price comparison table.
It is set out as follows:
B = price , C= supplier, code D = price, E = supplier, code F = Price, H = supplier code, J = Price, K, Supplier code, L = Price, M = supplier code, N = price, O = Supplier code.
Each row is a product, so I am trying to compare each suppliers price (B,D,F,H,J,L,N) per row and highlight the cheapest price.
Whenever I get it to work it looks for the cheapest price in the entire table rather than on a row by row basis.
how to highlight a particular cell red if the value in one cell is less than or equal to the value in another cell. For instance, How do I make it so that the "Hours to go" cell turns red if the value in the "Actual Last Completion" value is less than or equal to the value of "Last Completed" cell?
View 3 Replies View RelatedIs it possible to highlight a1:h1 if cell a2 contains dark?
i used this code in cell i1-->=MATCH("dark",a2,0)
and i dont know what's next, my friend in the office told me to use conditional formatting.
I have a query relating to conditional highlighting - specifically highlighting a cell's column and row based upon whether it contains data or not i.e. if it is blank, it's column and row remain unhighlighted, but when it contains data, it's column and row should become highlighted. I could probably manage this myself but I have a few more specific requirements which I have illustrated with a few screenshots, however I can't see how to make these available to view here!I
View 1 Replies View RelatedI am wanting to highlight the ID's on list 2 which don't appear on list 1 and vice versa highlight the ID's on list 1 which don't appear on list 2.
View 2 Replies View RelatedI am using this Formula =Sum(Offset(A1,,,D1)) where I put for example number 4 in D1 and I get the sum starting cell A1 till Cell A4
I want the range to be highlighted as well, but I don't know how to do it.
I want to have Excel highlight one or two numbers/cells in one column based on the value in another cell. I am attempting to do this using Conditional Formatting.
For example, if X1 is BETWEEN A2 and A3, I want to highlight A2 AND A3. I have used various AND and IF functions to achieve this goal.
Also, if X1 is EQUAL to A2, I want A2 to be highlighted. This is easy to do with a simple formula.
But my problem is this: if X1 is equal to A2, I want ONLY A2 highlighted. If X1 is between A2 and A3, I want BOTH A2 and A3 highlighted. I cannot figure out how to achieve both. For example, when X1 = A3, A2 AND A3 are being highlighted, instead of just A3. I would prefer to do this without a macro, if possible. Can this be done?
Example formulas I have tried which easily achieve the highlighting of two cells when the value is between them:
Condition 1=IF(AND($I$35>I8,$I$35<I7),1," ")+IF($I$35<>I7,1," ")
Condition 2=IF(AND($I$35<I6,$I$35>I8),1," ")+IF($I$35<>I7,1," ")
It appears that the +IF, etc. functions are not doing anything.
This is more complicated by the fact that the value of, in the above example, I35 is based on a value from another sheet (I used a function to transfer a value from one sheet to I35 in the other sheet). As data are entered on Sheet1, the value in I35 in Sheet2 changes.
I'm having issues with conditional formatting. I used the INDIRECT formula to highlight specific rows.
For example, column A has the days of the week. I wanted the whole row highlighted if it was a Saturday. I used:
=INDIRECT("a"&Row())="Sat"
What I want to do now is to highlight specific cells (Columns F and G) if column A has Friday in it. I do not want the whole row highlighted if it contains Friday.
Well I spent some time yesterday trying to figure this one out. It was only last week that I have taught myself how to use VBA in excel. However this looks like a though one.
Simply what i would like to do is highlight a column of a certain date (till a certain row number) based on a list of dates.
eg. Across the top I have a set of dates and on another sheet i have a list of dates.
I understand that there is a VBA code for such conditional formatting but i can't get my head around it.
I have 2 worksheets. One has locations with numbers, example:
275 Location 1
276 Location 2
I have all my locations on the second sheet, but in 2 different columns, listed with numbers only, example:
271 275
272 300
I have 2 scenarios I need help with.
1st:
If any of the numbers on sheet 1 match the numbers in column 1 on sheet 2, highlight the number on sheet 1 in green If any of the numbers on sheet 1 match the numbers in column 2 on sheet 2, highlight the number on sheet 1 in red
2nd:
If the number on sheet 2 matches any number on sheet 1, highlight green
I want these to apply to all the cells that have numbers (it could apply to all cells I guess as it should ignore it if it doesn't match, I would assume)
I want to highlight all the cells in a worksheet that have dropdown lists in blue color. Not sure how to do it.
View 13 Replies View RelatedI have a data with say around 500 rows and want to determine MAX for each row and HIGHLIGHT them, also if data in all cells is zero then it should ignore and highlight none.
I have tried this formula
=B2=(MIN(IF($B2:$E2>0,$B2:$E2))).
But this highlights all the zeroes, you can refer attachment for sample..
I'm using Excel 2010 on my Mac. I would like to set up the data as follows:
A
B
C
D
E
F
NAME
DATA X
DATA Y
DATA Z
DATA XX
DATA YY
NAME
90%
88.2
410
88.4%
97.8
[Code] ........
Now what I would like to do is have the data in each column highlighted a certain color based on specific ranges. For example in Column B I want anything from 92% - 100% highlighted blue. I would like 83% - 91.9% highlighted purple, and anything under 83% highlighted red. Do I need to have a conditional format entered in each cell? Can I set up a conditional format for the whole column? Once I can figure the formatting in my example the remaining columns will be a breeze since they will be set up in the same manner just different number ranges, same colors will apply.
I have a spreadsheet with one column. For example, it contains
A
A
A
A
B
B
C
C
C
D
D
I want to highlight the A's and don't highlight the B's and then highlight the C's and then don't highlight the D's and so on. I want to highlight or not highlight the entire row.
Range from AK1:AK8 to AT1:AT8. These are eight rows, total eighty entries. Can a formula or conditional formitting determine if there are duplicates values in eighty entries . The need is not column-based rather row based.
View 10 Replies View RelatedSee attched spreadsheet. I would like excel to highlight the rows where a value (model) = *.* (ie: not a whole number). I think the attached spreadsheet explains it better.
View 2 Replies View RelatedI am using a 2007 excel spreadsheet and on parts of it I can't just highlight one horizontal row of cells, it wants to highlight three down. I suppose that I have asked it to do this but I can't for the life of me undo it.
I have tried unmerging cells, cutting and pasting somewhere else, but nothing works.
Can anyone help me please as it's driving me to distraction?
I found this spreadsheet on here and I have been trying to customize it to what I need. I am trying to have scores from skins match highlighted. I want only the minimum score to be highlighted but if there is another duplicate minimum score I don't want it to highlight anything. I also need to find a way to count the skins won by each player and have it off to the side.
For those not familiar with golf a Skin is a game where you try to get the lowest amount of strokes on a specific hole. Ex- 4 people play the hole one. P1 scores 4, P2 gets a 3, P3 and P4 get 6. The skin would go to P2 who has the lowest score on that hole.
Highlight lowest number in each column not highlighting if there are duplicates starting at L6 down to L11 and for each column till AC. And the same for the group just to the right on attached file.
On row 13 and 14 it tells me who won a skin. I want to tally up the total skins won by each player. so if Joe's names shows up twice on R14 I want it to tell me somewhere in the sheet Joe = 2
I have created a spreadsheet to find cyclical patterns and my next task was to sort these patterns from highest value to lowest.
Next I need to start from the first row of the sorted spreadsheet and find the first row working down that repeats. Once I find his row I have to stop the search and highlight both the original and repeated rows. If the first row has no repeat it has to move to the second row and do the same operation until it finds a row that does repeat and so on.
I have two sheets
1. On one I have sheet named leave with five columns
2. Second sheet has calender
Sample file is attached for reference sample.xlsx
What I want is that as i enter leave dates on sheet "Leave" corresponding rows on calender sheet should highlight and important thing is if i change the name row highlight should change automatically. This i could achieve with following function
[Code] .....
The problem here is that it does it once but for second time it does not show...
I am trying to write a macro in VBA excel 2010 that compares 2 sheets.
The macro should be something along the lines of if column 7 on sheet 1 = column 1 on sheet 2
AND
on that same row if column 6 on sheet 1 = column 3 on sheet 2
highlight green
** also on sheet1 there can be the same batch ID so if it is the same batch ID it needs to calculate the sum and look at that amount...
Sheet1:
settleid
min Tran Date
Payment Vehicle
total Deposit
total CF
total MRI
RMBATCHID
475-T
03/03/2014
Connect
$562.95
$19.95
$543.00
6G000001450835
[Code] .......
Results >
Sheet1:
settleid
min Tran Date
Payment Vehicle
total Deposit
total CF
total MRI
RMBATCHID
475-T
03/03/2014
Connect
$562.95
$19.95
$543.00
6G000001450835
[Code] ..........
In column J of my Excel 2003 worksheet named: Sheet1, is a list of mailing addresses.
I need a macro please to delete the entire row if any of the following conditions occurs:
1. The cell is blank or
2. The cell contains the works: No Address, BUNGENDORE, NSW 1111
Please note that the words: "No Address, BUNGENDORE, NSW 1111" may appear in either Upper-case, Lower-case or Proper-case.
I have attached a sample copy of my spreadsheet and highlighted in yellow the cells that meet the above-mentioned criteria.
As such, the entire rows: 4 and 11 of my sample spreadsheet would need to be deleted.
I want to be able to have rows/cells generated with a certain text
based on the answer given by a user.
For example, My question in a cell could be "how many groups have you made?".
Now to this if the user answers "3" then I would want three cells below to
ask "what is the name of your first group", "what is the name of your second
group" and so on.
I have a spreadsheet with 10 columns and 8000 rows. column 2 contains names and 3 contains districts of residence.
I need to highlight (or delete) whole rows of duplicate entries in the name column(2) that are in the same district (column 3).
Traditional conditional formatting highlights all duplicates. I just need those duplicates in column 2 that have the same text in column 3.
I have rows of information linked to other sheets with forms to fill out (master sheet). I want to be able to have a red fill if one of the cells is blank, which I do have working now, but I want a clear row if the "indicator cell" is blank.
View 1 Replies View RelatedI have a spreadsheet for recording property maintenance. All properties are grouped by a city zone in a specific colour, and there is conditional formatting on this. Also drop down lists for properties, contractors etc.
This all worked well, until I needed to start inserting rows. All the conditional formatting and lists didn't replicate on the newly inserted rows.
Also, we need to assign a unique reference number to each row but currently manually inputting them - very inefficient way of doing this as they will inevitably get mixed up and confused as rows are removed.
Spreadsheet.jpg
I have a spreadsheet of a couple hundred products, their sales over the last 18 months, and then each product's 18 month average monthly sales. What I would like to do is format them so if any of the months' sales are below their respective average, that cell/month with be highlighted. Excel told me that I cannot do this for multiple rows at a time, and I don't want to go row by row for this many products. Attached is a sample file of the first row.
View 4 Replies View RelatedI have a worksheet (Data Lookup) that initially I just required row 1 to be frozen. Now my worksheet would be much easier to read if I was able to freeze row 115 and row 263 when they reached the top of the sheet respectively.
e.g. Row 1 frozen, when I scroll down the sheet and row 115 hits row 1 that would also be frozen and the same with row 263 when it comes into contact with row 115.
I have looked around and cant find a solution and to be honest I'm not sure if it is even possible.
I'm running a spreadsheet at the moment in 2007, and one of the funcitons I've made it for certain cells to either change format if the number is to big or to small depending on the cell it is.
I have formatted all for one line against duplicate scores on the same line.
The problem is this is time consuming and there are 22 different lines.
Because with Conditional Formating you can't simply drag like you can with formulas, I was wondering if there was a more simple approach. I have demonstrated the formating required on Row 6, and require the same formating on rows 8:10, 14:26, 32:36.
Also, just to make things complicated, the values change for each line.
I have attatched the file. Row 6 with the label DEMO LINE contains all the correct formating I require.