Formula to put a cell highlighed

**syllence** · 08-08-2008, 07:31 PM

Hello all,

I would like to create a report for work sheet1, in this report i would like to highlight all the clean containers, to know if those containers are clean we have to check the bookings, i would in fact like to write on sheet3 my list of clean bookings, that Excel pick the similar booking on sheet2!U:U with its assigned container/s on sheet2!C:C and that it goes and finds the same container numbers on my report sheet1 and highlight them.

It's pretty hard to explain like this but i hope you understood what i meant and that you are goint to be able to help me.

Thank you heaps in advance.
Fabien

**davesexcel** · 08-08-2008, 07:50 PM

Try conditional Formatting, the trick is to name the range you want to match if you are using a list from another sheet.
Check out the example below.

**syllence** · 08-08-2008, 08:12 PM

Thanks for your answer.

The thing is that it s a bit harder than that, as this is from the booking on sheet2!U:U that Excel has to take the container assigned to it on sheet2!C:C and then highlight it in sheet1!F:F

If you know what i mean...
Fabien

**davesexcel** · 08-08-2008, 09:05 PM

Originally Posted by syllence

Thanks for your answer.

The thing is that it s a bit harder than that, as this is from the booking on sheet2!U:U that Excel has to take the container assigned to it on sheet2!C:C and then highlight it in sheet1!F:F

If you know what i mean...
Fabien

Sorry, I don't understand......