| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
find match and replaced.
Hi,
anyone know how to find a # in columns F-I and match the # in columns A-C then replaced that box to empty and fill in red color. A B C F H I ------------------------------------------------------- 1 6 11 3 12 9 2 7 8 13 4 14 5 10 15 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find match and replaced.
One simple formulas & CF play which produces
the desired results in an adjacent area Assume source data in A1:C5, data to be compared in F1:I1 Put in K1: =IF(COUNTIF($F$1:$I$1,A1),"",A1) Copy across/fill down to M5 to cover an area equivalent to the source data in A1:C5 Then select K1:M5 (with K1 active), apply conditional formatting using Formula Is: =K1="" Format Red fill / white font Ok out K1:M5 will return the results that you seek -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "John" wrote: Hi, anyone know how to find a # in columns F-I and match the # in columns A-C then replaced that box to empty and fill in red color. A B C F H I ------------------------------------------------------- 1 6 11 3 12 9 2 7 8 13 4 14 5 10 15 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find match and replaced.
Max,
thanks for the help..... "Max" wrote: One simple formulas & CF play which produces the desired results in an adjacent area Assume source data in A1:C5, data to be compared in F1:I1 Put in K1: =IF(COUNTIF($F$1:$I$1,A1),"",A1) Copy across/fill down to M5 to cover an area equivalent to the source data in A1:C5 Then select K1:M5 (with K1 active), apply conditional formatting using Formula Is: =K1="" Format Red fill / white font Ok out K1:M5 will return the results that you seek -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "John" wrote: Hi, anyone know how to find a # in columns F-I and match the # in columns A-C then replaced that box to empty and fill in red color. A B C F H I ------------------------------------------------------- 1 6 11 3 12 9 2 7 8 13 4 14 5 10 15 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
find match and replaced.
welcome, John.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "John" wrote in message ... Max, thanks for the help..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Accidently replaced a spreadsheet that I did not want replaced | Excel Discussion (Misc queries) | |||
| how do you find a excel spreadsheet that you replaced with a new | Excel Worksheet Functions | |||
| Using MATCH to find the 2nd match, not only 1st | Excel Discussion (Misc queries) | |||
| find and match the max | Excel Worksheet Functions | |||
| find and match the max | Excel Worksheet Functions | |||
Linear Mode
