PDA

View Full Version : Solved: Match & Fill



ndendrinos
08-04-2007, 08:25 AM
Bonjour,
The project is the following:
Customer calls the call centre to discuss his/her account.
When agent brings up his "profile" the missing services the company can offer are filled in yellow.
Only the services not already billed for need to be highlighted on Sheet1
The services are listed on Sheet 2
The headings with the amount underneath them can be anywhere on the sheet (1)
For this example the range of the sheet is limited to A1:H16
Thank you

ndendrinos
08-04-2007, 04:01 PM
On second thought I think going with conditional formats simplifies things.