adding red line when column "B" = Saturday

[invgrp]

I can't seem to get the conditional formating to work.

I want to have Column A through H underlined in red when the contents of Column B = "Saturday".

Comment: I manually underlined the columns to show what I'm looking for.

Thanks.

Bruce

xls attached

[CK76]

Your Day: column is actually date value that's formatted to show "dddd". Meaning you have to first use Text() to convert it to weekday text.

As well, you should change your formula reference to something like below.

Please Login or Register  to view this content.

See attached.

Edit: Alternately you can use =Weekday($B5)=7 as well.

[invgrp]

CK:

I knew I had something wrong.

I applies your suggestions and it works perfectly.

Thanks for your help.

Bruce