Need VB help

[golfduke]

I am using excel 2000.
How do I Change the format of a fields to Bold and Alignment Horizontal to Left indent and the Indent to the value of a field? This needs to happen for a range of rows. The range can be variable depending on how much data is in the spreadsheet.
So if Field b2=2 I want to field A2 Bold and Horizontal of Left Align and Indent of 1-B2 (so indent of 1).
Conditional formatting does not do it.
I am not familiar with VB enough to do this by myself.

Thanks

Steve

 

[Smitty]

Welcome to the Board!

You can record a macro applying the settings you want. If you post the code you get someone can tweak it to be dynamic.