Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Assistance
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Assistance
Check your first post.
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 -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Assistance
As stated earlier
=ISNUMBER(MATCH(DATE($C$2,D$3,$C6),$S$3:$S$8,0)) -- Regards, Peo Sjoblom http://nwexcelsolutions.com "JimMay" wrote in message news:wD79g.28102$fG3.23983@dukeread09... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Assistance
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting Assistance
Uzytkownik "JimMay" napisal w wiadomosci news:wD79g.28102$fG3.23983@dukeread09... 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 i would put next to your dates any sign ("x"?) then in cond formatting in formula i would use vlookup if it finds x then your conditioning criteria mcg |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
Conditional Formatting Error | Excel Worksheet Functions | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |