|
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
---
|