Below is a small bit of code that will make a row bold depending on
value in column Q.
I can make it work if the value in Q is text, however I need it to rea
a datevalue. Is there a way to do this?
What I really would like to be able to do (though I was going to tr
and work that one out for myself, small steps) is to make it referanc
two dates in cell user definable cells and bold anything they input
But the first step is to make it read dates..
Any ideas?
Code
-------------------
Sub bold()
Set Rng = Range("Q1:Q5000")
For Each cl In Rng
If cl.Value = "21/03/06" Then
cl.EntireRow.Font.bold = True
End If
Nex
-------------------
Thanks Very much
End Su
--
Odysseu
-----------------------------------------------------------------------
Odysseus's Profile:
http://www.excelforum.com/member.php...fo&userid=1456
View this thread:
http://www.excelforum.com/showthread.php?threadid=52486