Not sure if this will work. I have a cell with fields #'s (ie. 4A, 4B,
4C....); in the next colum is time (ie 9 am, 10 am, 11 am .....). How can i
get the cells to highlight if I have 2 saying 4A - 9 am. Could not get
conditional formatting to do it. Using Office 2003. Hope this makes sense.

Thanks
--
thomp

Are you meaning'


Formula Is =AND(A2="4A",B2="9 am")

or something like that where A2 and B2 are top most cells in the
selection to highlight.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122338

Thanks for the reply, I should try to explain better. A2 is 4A, B2 is 9 am,
if anywhere in A3 thuru A100, B3 thru B100, the combination of 4A 9am shows
up I would like it to highlight.

Hope that is explained better
--
thomp


"NBVC" wrote:


Are you meaning'


Formula Is =AND(A2="4A",B2="9 am")

or something like that where A2 and B2 are top most cells in the
selection to highlight.


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122338

Select A3:B100 and invoke Conditional Formatting through Format menu.

Select Formula is from 1st drop down and enter formula:

=AND(A3=$A$2,B3=$B$2)

Click Format and choose your colour scheme


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122338

Got it thank you,
--
thomp


"NBVC" wrote:


Select A3:B100 and invoke Conditional Formatting through Format menu.

Select Formula is from 1st drop down and enter formula:

=AND(A3=$A$2,B3=$B$2)

Click Format and choose your colour scheme


--
NBVC

Where there is a will there are many ways.
'The Code Cage' (http;//www.thecodecage.com)
------------------------------------------------------------------------
NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=122338