Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hello
Excel gurus. I am an amaeture to excel VBA, but I am sure its usage will make my life easier. Actually, there are few spreadsheet in which I applied conditional fomatting. The conditional formatting is based on a formula. However now i realised that I want to change that conditional formatting formula. Is there a way to update it on active spreadsheet using a macro. Conditional formatting that I want is following: Applies to $G$6:$M$16 Formula = =IF($L$16<-0.001,IF($L$160.001,0)) I want to change the colour of the applicable range to RED. Please help. Thanks to all excel gurus in anticipation. Regards Gaurav
__________________
Regards Gaurav |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting update issue | Excel Worksheet Functions | |||
conditional formatting or formulae to show elapsed dates | Excel Worksheet Functions | |||
Combine Conditional Formatting Rules formulae | Excel Discussion (Misc queries) | |||
Nested functions in conditional formatting formulae | Excel Discussion (Misc queries) | |||
Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) |