|Subject:||RE: Conditional Formatting help|
|Posted by:||Ron Coderre|
|Date:||Fri, 12 May 2006|
Maybe something like this:
Select S3:S9, with S3 as the active cell
Formula is: =(S3=DATE($C$2,$D$3,$C$6))
Click the [format] button and set the formats
Click the [OK] buttons
Is that something you can work with?
> 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>>
> Is there a work-around -- I wish to conditionally format the Dates
> listed in S3:S8.
> Thanks, in advance
Conditional Formatting help posted by JimMay on Fri, 12 May 2006