Can I use VBA or functions to apply conditional formatting in Excel?
Posted on 2009-12-20
I've got a whole bunch of Excel VBA functions that work really well and produce some data re disk space usage. The results are in TEXT format, for example:
500GB vraid1 (1000GB used), savings = 375GB
This means that conditional formatting won't work seeing as the cell's contents aren't a number.
Is there a way I can apply conditional formatting from within VBA? I know I can format cells as numbers etc but that's not what I'm after.
I'm specifically wanting to apply a data bar conditional format if the number at the END of the example above is a certain number (i.e. 375 would produce a blue bar).