Good afternoon,
I have created a March Madness Worksheet where in one tab I enter the winners as they advance and all other tabs with the members picks highlights in yellow if they win based on the input tab. I want to highlight the losers in red but not the cells where the game hasn't been played yet so it can't be as simple as IF(Sheet2!C7<>Sheet1!C7). I would appreciate any help with this.
perhaps a sample sheet
but you can use an AND
if you dont want
Sheet1!C7 if blank
then - you dont need the IF
=AND(Sheet2!C7<>Sheet1!C7, Sheet1!C7 <>"")
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
That works. Thanks for your help.
you are welcome
if my assistance has helped, and only if you wish to , there is a reputation icon * on the left hand side - you can add to my reputation here
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks