| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Automatic change color of searched value in a column...
Per below list, i want to change colour of a cell whose value matches with
CELL A1 contents. For example: A1 = 239.05 Column B 1) 235.66 2) 154.60 3) 239.05 4) 522.05 As I enter 239.05 in cell A1 it automatically change colour of CELL B3 (that's equal to 239.05). Any possibility? Be noted that it should seach for the first occurence only.. also what amendment can enable the proposed solution to search for all first & next occurence ? Regards, Syed |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW DO I CHANGE THE AUTOMATIC BORDER COLOR IN EXCEL? | Excel Worksheet Functions | |||
| When I change the style in column (a) a date, it also changes colu | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
| Automatic Change of X-axis | Charts and Charting in Excel | |||
| Is there an automatic way to change numbers such as 12312001 t | Excel Discussion (Misc queries) | |||
Threaded Mode
