Hi,

I have one work sheet in that work sheet I have one Column As
“Activity” and the other Column as “Finish Time”. Now what I want is
if I don’t put time in “Finish Time” filed and if I select any activity
on next row from the “Activity” Field, either it should not allow me to
select the activity or the activity should be colored with any color
say “Blue”.

I worked it out with conditional formatting , I first selected the
“Activity” field and put the formula as =isblank(m21) and chose the
color as red and I am getting the entire activity field colored as red.


--
mangesh


------------------------------------------------------------------------
mangesh's Profile: http://www.excelforum.com/member.php...fo&userid=6746
View this thread: http://www.excelforum.com/showthread...hreadid=543851