Highliting Entire Row Using Conditional Formating

[earthworm]

Guys

i want to highlight entire row using conditional formating from the RANGE

I Know how to highlight the entire row using only one row but i want to

highlight the row from the available RANGE !!

Example when i Entire Sunday it highlights the entire row

but if i enter monday it dosent work . How to make it work so that if i enter tuesday it highlight the tuesday row .




PLEASE GUIDE



Sample excel attached

[NBVC]

Go to F10 and invoke Conditional formatting..

Change formula to:

=IF($E10=$E$7,1,0)

(note no $ in front of 10 in E10)

Click Ok

Then copy F10 select the entire range F10:K14 and go to Edit|Paste Special and select Formats.

Click Ok.

[earthworm]

Go to F10 and invoke Conditional formatting..

Change formula to:

=IF($E10=$E$7,1,0)

(note no $ in front of 10 in E10)

Click Ok

Then copy F10 select the entire range F10:K14 and go to Edit|Paste Special and select Formats.

Click Ok.

Thank you very much for your assistance

I m proud to be this forum member

[NBVC]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save