Hey everyone. This is my first post here and I am looking for some help.
I am a wedding photographer and I have a spreadsheet set up with a few different tabs at the bottom.
One is booked weddings, one is wedding monies, and one is potential new clients.
I have conditional formatting done on my date column in the potential client list to be bold if there are duplicate dates
but what I would love to accomplish is to have the date column in potentials turn the text red if I have a booked date from my Booked Weddings tab.
If I put a date in the potential date column and there is already a date in the booked tab date column, then the potential date would turn red.
Hope this makes sense and is possible.
Thanks for any future help.
Regards,
Toby
Bookmarks