-
Hello, I'm new to excel 2011 (mac) and conditional formatting. I would like to color format the cell containing the lowest value in a given column and only color it if no other cells in that column have the same value. Any help/direction would be greatly appreciated. Thank you! RD
-
I inherited an EXCEL sheet that has the following formula as a rule for the conditional formatting of a group of cells: =NOT(#REF!=3). I have tried to find what values #ref! can take on but have not been at all successful, Can anyone say what values #REF! can have and what they mean, of just what the...
-
I have a large table (many rows and columns, and the numbers of both change from time to time). I want to have a column - call it "highlight" - such that an 'x' in the column automatically changes the background color of the whole table row in which the 'x' appears to something...
-
I have a spreadsheet with a number of conditional formats in it each one is based on different data, but for consistency's sake the colors have to align they are also laid out differently enough that I can't aggregate them together into one autofill-able formula (e.g. cells A1:C24, B30 and C45...
-
Hello and thank you for reading this, my first ever forum post. I have been driven to seek help for an issue i know you will able to help me with. Scenario: I have produced a spreadsheet to record student scores for a number of tests. each test has three cells to it 1: the score (entered by the instructor...
-
I have 3 sheets in my excel document. The first one is the main form and the other 2 are summaries that need to be populated and distributed the correct person depending if one value on Sheet1 begins with a letter between A-O or P-Z. What I need on each summary sheet is this sequence: On Sheet 2 in Cell...
-
Hi Guys, Good day to you! I am trying to make a training plan and record in one workbook. In training plan i have to put numbers, which represent for key training description and the other sheet - the training record i have to input the actual dates of training they undergone. So, when dates will be...
-
Hi Steve, Rather than use VBA, I've developed a worksheet only solution, using dynamic named ranges, LINEST linear regression function, datatables, index/match to pick out the best results, and finally solving the simultaneous equations and plotting!! Sorry I don't have time to explain the whole...
-
Hi all, Anyone who's used to the conditional formattings of Excel 2007? I need to format some cells in a given row, for instance make the beckground red, if the numbers of the cells are smaller than a number in another given cell in the same row. This should be done with 500 columns, and also repeated...
-
OS: Windows XP; MS Excel 2007 I need to update the "price" for a corresponding "Code". The updated Price is in a spreadsheet among as many as 15,000 "Codes" in a column and the corresponding "Price" is in another column in the same row. I need about 400 items updated...