Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi Hi,
To someone that can safe me. I need to do up a formulated worksheet. Lets say Cell A1(Red colour cell) and Cell A2(Blue colour cell) and Cell A3(Green colour cell) and Cell A4,B4,C4,D4,E4,F4,G4(Yellow colour cell) and Cell A5,B5,C5,D5,E5,F5,G5(Orange colour cell) These cells above will be key in with numbers.(numbers that i need t find) Column A to J row 8 to 500, will have thousands over numbers keyed i earlier.(numbers to be lookup) Now i need help in this, If those numbers to be lookup matches wit those key in above, that cell should change colour accordingly. And os able to give me an auto tabulate numbers of colour strike. Lets say "1000Red,500Blue,450Green,890Yellow,300Orange) Thank you for you help! I really need this help. Thank you a million, and may god bless this someone sweet and helpful. minde -- Message posted from http://www.ExcelForum.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Matching 2 list of data array, and return it as True if matched | Excel Discussion (Misc queries) | |||
EXCEL 2007 MATCHING ANSWERS | Excel Discussion (Misc queries) | |||
Matching numbers in an Array and returning values for matched numb | Excel Discussion (Misc queries) | |||
is there a formula to auto change cell colours | Excel Discussion (Misc queries) | |||
How do I have a list of possible answers auto put into a cell? | Excel Worksheet Functions |