Calander

[pwill]

Hi can any help with a formula to highlight text within a range that is equal to todays date

eg Range H4:N9

todays date is 28th Jan so the value in cell N8 (28) is auto highlighted in red

<colgroup><col style="mso-width-source:userset;mso-width-alt:1097; width:23pt" span="7" width="30"> </colgroup><tbody>
[TD="class: xl65, width: 30, align: center"] M
[/TD]
[TD="class: xl65, width: 30, align: center"] T [/TD]
[TD="class: xl65, width: 30, align: center"] W [/TD]
[TD="class: xl65, width: 30, align: center"] T [/TD]
[TD="class: xl65, width: 30, align: center"] F [/TD]
[TD="class: xl65, width: 30, align: center"] S [/TD]
[TD="class: xl65, width: 30, align: center"] S [/TD]

[TD="class: xl63, align: center"] 1 [/TD]
[TD="class: xl64, align: center"] 2 [/TD]
[TD="class: xl64, align: center"] 3 [/TD]
[TD="class: xl64, align: center"] 4 [/TD]
[TD="class: xl64, align: center"] 5 [/TD]
[TD="class: xl64, align: center"] 6 [/TD]
[TD="class: xl64, align: center"] 7 [/TD]

[TD="class: xl64, align: center"] 8 [/TD]
[TD="class: xl64, align: center"] 9 [/TD]
[TD="class: xl64, align: center"] 10 [/TD]
[TD="class: xl64, align: center"] 11 [/TD]
[TD="class: xl64, align: center"] 12 [/TD]
[TD="class: xl64, align: center"] 13 [/TD]
[TD="class: xl64, align: center"] 14 [/TD]

[TD="class: xl64, align: center"] 15 [/TD]
[TD="class: xl64, align: center"] 16 [/TD]
[TD="class: xl64, align: center"] 17 [/TD]
[TD="class: xl64, align: center"] 18 [/TD]
[TD="class: xl64, align: center"] 19 [/TD]
[TD="class: xl64, align: center"] 20 [/TD]
[TD="class: xl64, align: center"] 21 [/TD]

[TD="class: xl64, align: center"] 22 [/TD]
[TD="class: xl64, align: center"] 23 [/TD]
[TD="class: xl64, align: center"] 24 [/TD]
[TD="class: xl64, align: center"] 25 [/TD]
[TD="class: xl64, align: center"] 26 [/TD]
[TD="class: xl64, align: center"] 27 [/TD]
[TD="class: xl64, align: center"] 28
[/TD]

[TD="class: xl64, align: center"] 29 [/TD]
[TD="class: xl64, align: center"] 30 [/TD]
[TD="class: xl64, align: center"] 31 [/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl64, align: center"]
[/TD]
[TD="class: xl64, align: center"] [/TD]
[TD="class: xl64, align: center"]
[/TD]

</tbody>

any help would be apprieciated

regards

pwill

 

[My Aswer Is This]

So why did you decide to change sheet name that way?
Why not click on the sheet tab and change it there?
Double click sheet tab and change it there.

 

[pwill]

I was just ording my sheets so that they run in order because there are over 10 sheets when you get to two digits sheet10 goes to the top of list and sheets 1 to 9 follow.
It was just anoying me thats all.

 

[pwill]

I have names on the Tabs that I want to keep and I have the Tab names in a certain order on the sheet

 

[pwill]

That poor guy banging his head on your profile picture must be getting a headache by now I know how he feels lol

 

[My Aswer Is This]

That poor guy banging his head on your profile picture must be getting a headache by now I know how he feels lol

I like the challenges keeps my mine working. Hoping someone else will join in here and help you.