Timestamp Day Count

[aidanwhite]

Hi, I've currently got a load of timestamps in column J, generated by pressing a button. I wondered if anyone would be able to tell me how to get cell G10 to turn green if 3 or more of the timestamps are in the same day? Thanks!

 

[aidanwhite]

Sorry, I'm so confused.

Perhaps if I share a screenshot, we'll both be able to understand.

https://drive.google.com/file/d/0B4tF4wEdFYqURG40NFFnMkNLMDg/view?usp=sharing

In column J, there are 3 timestamps.
They are all from today.
Therefore I'd like them to change the colour of the cell selected (G10).
If I'd have only entered 2 today, this cell however would not change colour.

 

[oldbrewer]

my post 10 does that

if now you are asking only to look for 3 or more with todays date

in A1 put =today()
say your dates are A5 to A20

in B5 put =if(a5=$a$1,1,0)
copy down

in C1 put =sum(B5:B20)

in G10 cond format =C1>2