Hello,
What I am trying to do is to have the cell containing the Name on the LO Check Out sheet be highlighted if that name has No Loadout in the Notes Column on the LI Check In sheet.
Wb attached.
Thanks!
Hello,
What I am trying to do is to have the cell containing the Name on the LO Check Out sheet be highlighted if that name has No Loadout in the Notes Column on the LI Check In sheet.
Wb attached.
Thanks!
1. Select the range you want the CF to apply to - in your example sheet, B6:B205 on the 'LO Check In' sheet.
2. Use this formula in CF:
Formula:Please Login or Register to view this content.
3. Choose the highlight format you want (fill colour / text colour / etc).
That should do it.
Regards,
Aardigspook
I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
You don't need to give me rep if I helped, but a thank-you is nice.
Thank you! Exactly what I was looking for!
You're welcome, glad I could help and thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks