Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format to highlight only cells with formula, not const
I am trying to set up a spreadsheet that will change the cell color if the
formula in the cell has been replaced with a specific value. Is there any way to conditional format all cells that contain a formula, but not a constant? Herb |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format to highlight only cells with formula, not const
Hi,
Try this Go to the Name Manager (Ctrl+F3) and click on New (In Excel 2007). In Excel 2003, Ctrl+F3 would do. In the name box type cellhasformula and in the Refers to box, type the foll =get.cell(48,indirect(€œrc€,false)) Now go to conditional formatting and in Formula is, type =cellhasformula. Select the desired format Hope this helps. -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "hkbarnett" wrote in message ... I am trying to set up a spreadsheet that will change the cell color if the formula in the cell has been replaced with a specific value. Is there any way to conditional format all cells that contain a formula, but not a constant? Herb |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional format to highlight only cells with formula, not const
See this:
http://groups.google.com/group/micro...cf859ecd?tvc=2 -- Biff Microsoft Excel MVP "hkbarnett" wrote in message ... I am trying to set up a spreadsheet that will change the cell color if the formula in the cell has been replaced with a specific value. Is there any way to conditional format all cells that contain a formula, but not a constant? Herb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format to Highlight the Active Cell | Excel Worksheet Functions | |||
Conditional Format to highlight entire row if a condition is met | Excel Worksheet Functions | |||
Conditional Format to Highlight entire Row? | Excel Worksheet Functions | |||
Conditional Format to highlight entrire Row | Excel Worksheet Functions | |||
Conditional Format to highlight blank cell | Excel Worksheet Functions |