Select cells S3:S8 (S3 is the active cell)
Choose FormatConditional Formatting
From the first dropdown choose Formula Is
In the formula box, type:
=S3=DATE($C$2,$D$3,$C$6)
Click the Format button, and set your formatting
Click OK, OK.
JimMay wrote:
Was trying to enter in Conditional Formatting the following Using the
Formula Is: << c/f's perhaps don't take arrays - which In my case are
Holidays during the year
=if(Date($C$2,D$3,$C6)={$S$3,$S$4,$S$5,$S$6,$S$7,$ S$8},True)
Is there a work-around -- I wish to conditionally format the Dates
listed in S3:S8.
Thanks, in advance
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html