-
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...
-
As an alternative I would suggest using a set of radio buttons (rather than checkboxes) from the forms toolbox. Then you could simply use conditional formatting to grey out your other rows, based upon the value of the cell linked to the radio buttons. I will see how I go at attacking a sample spreadsheet...
-
bman1965 Simply, you can't bring through formats with a function. It can be done with code but it's complexity will depend on the number of different formats you are wanting to handle. What it appears you want to do though is use Conditional Formatting (C/F) throughout the workbook and whatever...