| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Check colour of number, then populate cell
Hello there,
Please help! I have coloured certain numbers either blue or red. My spreadsheet is as follows: Column A B C D E Row1 12 30 17 25 2 Row2 32 18 4 11 41 Row3 3 26 19 39 12 Row4 27 19 21 3 16 Row5 I want to populate Row5 with values and I need Excel to look at each cell and do the following: - eg. Identify the column/s with no coloured number - When this column/s is found, take the respective values in Row4 of the column and populate Row5 cells from left to right. Thanx for your help! -- KCG |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check dates in spreadsheet against expiry years column and change colour | Excel Worksheet Functions | |||
| Colour cell when number changes | Excel Worksheet Functions | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
| Change cell Colour when a number of days have been passed | Excel Discussion (Misc queries) | |||
| Change colour of Text if number in cell exceed limit | Excel Worksheet Functions | |||
Threaded Mode
