Hi All,

I have two worksheets using numeric values:

Sheet1 Range N17:N100 (84 Rows)
Sheet1 Range K17:K100 (84 Rows) - If condition is met apply Strikethrough
Conditional Format
Sheet2 Range K197:K280 (84 Rows) - Named Range "YR2006"

I would like a Conditional Formula to set criteria below and apply CF:
IF a cell value in Sheet1 N17:N100 is 0 (greater than zero) AND = (greater
than or equal to) its corresponding cell value in Sheet2 Named Range "YR2006".


The cells in Sheet1 Range N17:N100 should be compared individually to their
corresponding cell in Sheet2; ie. Sheet1 N17 is compared to Sheet2 K197,
Sheet1 N18 is compared to Sheet2 K198 and so on.

Thanks
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200701/1