Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

BerGaur

macrumors regular
Original poster
Dec 12, 2011
108
0
Inside my head
I have made a calendar based spread sheet witch counts hours. It is very detailed and is heard to find the correct date so I can log hours in. I want to be able to have the day highlighted in some way. Maybe by having the cell directly above it bassically saying:

=((2B)IF, true=today, printf"Today", IF, false (leave blank))

Now I know this is totally wrong, I don't know a lot of code at all, and I never learned IF commands. I hope this is close enough to give the point of what I want to do. Please help.
 

BerGaur

macrumors regular
Original poster
Dec 12, 2011
108
0
Inside my head
OH I'M GOOD! I found out what it is.

It is this:

=IF(B2=TODAY, "Today", " ")

Now, if TODAY is TRUE, it will print, "Today", and if TODAY is FALSE, it will print, " ".

In other words, if "B2" shows today's date, it will print, "Today" in the "IF" field, and if it shows anything other than today's date, it will literally print a space.
 
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.