| Home |
| Search |
| Today's Posts |
|
#8
|
|||
|
|||
"Bob Phillips" wrote
=OR(WEEKDAY(A$1,2)=6,WEEKDAY(A$1,2)=7) =WEEKDAY(A$1,2)5 <vbg Urrgh .. you got me there ! Much neater. Thanks. I forgot a week has a max of 7 days & Sat/Sun are consecutive ! <bg -- Rgds Max xl 97 --- GMT+8, 1° 22' N 103° 45' E xdemechanik <atyahoo<dotcom ---- |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formating Extreme Question | Excel Worksheet Functions | |||
| Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
| Conditional Formating | Excel Discussion (Misc queries) | |||
| more than 3 conditional formating in excel | Excel Discussion (Misc queries) | |||
| Conditional Formating when result is text | Excel Worksheet Functions | |||
Threaded Mode
