Conditional Formatting - Highlighting specific cells

[jlo33]

I'm having issues with conditional formatting. I used the INDIRECT formula to highlight specific rows.

For example, column A has the days of the week. I wanted the whole row highlighted if it was a Saturday. I used:

=INDIRECT("a"&Row())="Sat"

What I want to do now is to highlight specific cells (Columns F and G) if column A has Friday in it. I do not want the whole row highlighted if it contains Friday. Can anyone help me?

Thanks!

[Debraj Roy]

I think a simple

Please Login or Register  to view this content.

and applying the same CF to all required ROW is enough..

only if SAT is a general Text.. Not any Date Format using "ddd"..

Regards,
Deb

[FDibbins]

Is the data in A text (the word SATURDAY etc) or a date (6/7/2013)?
1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
If A is text...
4. enter =$A1="SATURDAY"
if A1 is a date...
4. enter =WEEKDAY($A1,1)=7

For the 2nd part, highlight just those 2 range of cells...
follow the directions above but change to either FRIDAY or =6

[jlo33]

Thanks!

Got it to work.

[FDibbins]

Happy to help, based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.