Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
if cell contains formula change background colour to pale yellow
I'd like to be able to do this:
if cell contains formula change background colour to pale yellow how would I write that in vba, please -- Regards, David Lindstrom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
if cell contains formula change background colour to pale yellow
David here is one way
Sub Color_Formula_Cell() On Error GoTo e: With Cells ..Interior.ColorIndex = 0 ..SpecialCells(xlFormulas).Interior.ColorIndex = 36 End With Exit Sub e: MsgBox "There are no formulas or the sheet is protected" End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "Max Bialystock" wrote in message ... I'd like to be able to do this: if cell contains formula change background colour to pale yellow how would I write that in vba, please -- Regards, David Lindstrom |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
if cell contains formula change background colour to pale yellow
Paul,
That's terrific thank you. That's just what I wanted. -- Regards, David Lindstrom "Paul B" wrote in message ... David here is one way Sub Color_Formula_Cell() On Error GoTo e: With Cells .Interior.ColorIndex = 0 .SpecialCells(xlFormulas).Interior.ColorIndex = 36 End With Exit Sub e: MsgBox "There are no formulas or the sheet is protected" End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2000 & 97 ** remove news from my email address to reply by email ** "Max Bialystock" wrote in message ... I'd like to be able to do this: if cell contains formula change background colour to pale yellow how would I write that in vba, please -- Regards, David Lindstrom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change background colour | Excel Worksheet Functions | |||
Change background colour of a row if a particular cell has a value | Excel Discussion (Misc queries) | |||
how do i change cell background colour depending on its content? | Excel Discussion (Misc queries) | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
change background colour | Excel Discussion (Misc queries) |