| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
how can I format sheet 1 if the value is found in sheet 2?
I'm all employee data in sheet 1, in sheet 2 I'm using vlookup function to
retrieve employees for whom I issued certificates on a each day. My question is, how I can mark those employees in sheet 1 for whom Ive already issued certificates from those for whom I didn't. I tried conditional format function, but it didn't work, as it is in the separate sheet. Thank you for your help |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how can I format sheet 1 if the value is found in sheet 2?
Try the responses in your later post ..
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Samad" wrote: I'm all employee data in sheet 1, in sheet 2 I'm using vlookup function to retrieve employees for whom I issued certificates on a each day. My question is, how I can mark those employees in sheet 1 for whom Ive already issued certificates from those for whom I didn't. I tried conditional format function, but it didn't work, as it is in the separate sheet. Thank you for your help |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
how can I format sheet 1 if the value is found in sheet 2?
Try the responses in your later post ..
... and post some feedback to the responders over there (This is a discussion group, not a dartboard) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format size of finished sheet? | New Users to Excel | |||
| Format data Sheet size? | New Users to Excel | |||
| Lookup function and compare | Excel Discussion (Misc queries) | |||
| How to Format Excel Sheet ToShowRowNumbers but not the column alph | Excel Discussion (Misc queries) | |||
| Can a macro format a hidden sheet? | Excel Discussion (Misc queries) | |||
Hybrid Mode
