More than 3 conditional formatting

[silverskye787]

hi..

Look at the following attachment. need some help here.. how do i create another conditional formatting for the date in A5 (sheet1)?

any help to guide along?

[VBA Noob]

Just use one condition

=OR(B1=date1,B1=date2,B1=date3,B1=date4)

if you need more than one colour then it would be a macro

VBA Noob

[silverskye787]

Just use one condition

=OR(B1=date1,B1=date2,B1=date3,B1=date4)

if you need more than one colour then it would be a macro

VBA Noob

hmm.. but i want the dates in sheet1 to corresponds to the date in sheet2.

meaing that the user will type in any dates in sheet1 and it will hightlight the date type in in sheet2.

Eg. if the date in sheet1 is 1/1/2007 then in sheet2 the date highlighted should be 1/1/2007 and so on.

the colour can be the same.

[VBA Noob]

Try

=COUNTIF(INDIRECT("Sheet1!$A$2:A"&ROW(A2)),B1)>=1

VBA Noob

[silverskye787]

Thanks alot for your help.. It solved my problem..

http://www.ozgrid.com/forum/showthre...d=1#post369175

here is also another solution to the problem.

[VBA Noob]

Please read forum rules below. Cross post without a link are not permitted. This and any future posts will be locked unless you agree to the rules. PM me if you wish to continue posting here

VBA Noob