View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default what formula do I use for conditional formatting?


=AND(A1<"",WEEKDAY(A1,2)5)

"CoopsCoops" wrote:

Now that I have my "ddd" showing Sat, Sun, etc., I need to place conditional
formatting that will turn all cells equal to Sat, Sun to Red text. What
formula do I use in the conditional formatting to produce this?