Conditional Formatting of Font Color based on Values in another cell

[dpcp]

Hi everyone

I was hoping you could help me with some VB code for conditionally formatting a column of cells...

I have attached a dummy workbook, and basically the values in column F are in white. I would like these values to turn to black font, but only after all the corresponding values in column H have been filled in (between 1-5).

I have a macro in my actual workbook, which is why I need it as code and not a formula in the cell.

Thanks for your help!!

DP

[swoop99]

Haven't looked at your workbook but.....see below for the code to change cell formatting. Put the vba code into the change event of your worksheet so it runs every time a user enters a value anywhere.

Please Login or Register  to view this content.

[dpcp]

I've put it in but I get an error. Also, not all the cells in column H will have values between 1-5, and it depends on the rest of the macro how many rows there will actually be... bu for this one, I need something that says
"If all cells H4:H25 have a value between 1-5, then font colour in all cells F4:F25 = black"

[swoop99]

Just to be clear here: "If every cell in the range H4:H25 has a value between 1-5, then font colour in every cell in the range F4:F25 turns black, otherwise it's white"?

ok. Try this:

Please Login or Register  to view this content.

[dpcp]

Thank you so much, that seems to work perfectly

[swoop99]

You're very welcome.