|
|
Thread Tools | Display Modes |
#16
|
|||
|
|||
Anything you can do to point me in the right direction would be appreciated.
|
#17
|
|||
|
|||
Your original question was:
I need Column D to show an "x" if the adjacent cell in Column C (dollar amounts) falls within the Top 30% by date. If it is simply a question of the time of day in a column cf. I'd still have to copy and paste the Time of Day into a column then see column F in the attached. But be aware that on my system the file is almost impossible to work with due to slowness. It might be of some help to set Calculation to Manual (File, Options, Formulas, Calculation options, Manual, OK), but then you must remember to press F9 each time you change something in the file. If you can't work with it you might want to ask your question in some VBA forum. I have no further suggestions. |
#18
|
|||
|
|||
Quote:
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Distribute text in one cell across a range of cells (overcoming selection.range.cells.count bug) | slaycock | Word VBA | 0 | 02-18-2017 07:00 AM |
Conditional formating all cells in an array based on adjacent cells | deejay | Excel | 6 | 12-20-2016 12:00 PM |
Excel Formula: return a range of cells that match | tinfanide | Excel | 4 | 08-30-2014 07:03 AM |
Color-fill a range of cells, based on text in a different sheet. Possible? | unittwentyfive | Excel | 2 | 06-01-2014 06:48 AM |
Sum Formula in the range with Numeric and NonNumeric data cells | Spanec | Excel | 2 | 01-12-2012 09:15 AM |