| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting - 2 Worksheets one Named Range
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting for range of cells? | Excel Worksheet Functions | |||
| sorting a range with conditional formatting | Excel Worksheet Functions | |||
| How do you Identify text as a named range in excel | Excel Discussion (Misc queries) | |||
| Need formula to lookup a named range | Excel Discussion (Misc queries) | |||
| Conditional formatting on named text field | Excel Discussion (Misc queries) | |||
Threaded Mode
