Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All
This will be an easy one for you experts I need help with a macro to solve the following Range N3:N200 if any cell in the range has a value of either 40 or 80 then in the Range O3:O200 the cells will have a value of 0(zero) formatted as 0.00 - Do not need any cell or text colours. I would put a command button on the sheet and assign the macro -- Many Thanks Sue |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Format Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional number format in Excel 2007 | Excel Discussion (Misc queries) | |||
Conditional Format - Excel 2007 | Excel Discussion (Misc queries) | |||
Excel 2007 Conditional Format with Formula | Excel Discussion (Misc queries) | |||
Conditional format oddity in Excel 2007 | Excel Worksheet Functions |