Format range based on changing value in another cell

[mkpippin]

Hi all, hoping someone can help me out

I am trying to change the formatting of a range of cells (G:BM) to two decimal places if the value in cell D1 changes to "SpecificText"

Another small wrinkle in the code, I'm wanting this to run every time the value in D1 is updated.

This seems like it should be easy, but I'm not the best with VBA. Any help you can provide is greatly appreciated

Thanks!!

 

[JoeMo]

You don't need VBA. Easily done with conditional formatting.
1. Select G:BM with your mouse
2. Home>Conditional Formatting>New Rule>Use a formula
3. Formula is: $D$1="Specific Text"
4. Choose number format wanted and click OK