Highlight the day of today

G

Guest

Hello Fellow excel(lent) users,

I am trying to make a small timesheet in which I wanna highlight todays day.

I use 4 columns:
A = Number range from 1 to max 31 (being days of the month)
B = Time punched in (to start working)
c = Time Punched out (finish work)
D = Subtracting B from C and an extra 30 mins.

In Field F1 I have the form =TODAY(), to know which day it is today.

What I want now is to highlight todays entries by using special formatting.
But the formula does not seem to work. =IF(--(DAY($O$1)=A3))

So today it is the 14th of october, which means the row of the fourteenth
should be highlighted by a yellow pattern and black bold letters.

Please help !!
 
B

Biff

Hi!

Assume your data is in the range A2:D32

Select that range
Goto Format>Conditional Formatting
Formula is: =DAY($F$1)=$A2
Click the Format button and select the styles you want

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparing two workbooks and highlighting the differences 2
[Flashing] RED before renewal date 1
Name The Day Of The Date2 5
Using TODAY, lookup and add values from a column 1
Naming Of A Day In The Month 9
Row highlight based on the 1-31 day of the month 8
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
Count the Number of Weekdays by Month 3

Top