| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting In and Across Sheets
Thanks Max!
"Max" wrote: "jkl" wrote: .. =AND(M$2=$E7,M$2<=$F7) where E7 and F7 each contain a date But if I try to use that condition to refer to e7 and f7 in a different sheet, I'm not allowed to do it . . . You could also try INDIRECT, something along these lines .. Assuming E7 and F7 are in Sheet2, use as the CF formula (in say, Sheet1): =AND(M$2=INDIRECT("'Sheet2'!E7"),M$2<=INDIRECT("' Sheet2'!F7"),INDIRECT("'Sheet2'!E7")<"",INDIRECT( "'Sheet2'!F7")<"") Above contains 2 additional checks to ensure that E7 and F7 in Sheet2 are not blank. These will help to prevent false indications caused by blank cells. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Threaded Mode
