Using condition format to check if day equals Friday

Originally Posted by Zyphon

I have a formula using weekday and a lookup table to show the days of the week Sunday being 1 and Saturday being 6 the lookup table will return the day name respectively

You don't really need a LOOKUP table for that. If you have a date in A1 you can return the day of the week with the formula

=TEXT(A1,"dddd")