Change text color of a range of cell

Why don't you use conditional formatting?


Sent from my iPad using Tapatalk

I'm not actually very familiar with conditional formatting for such case, as the value in Range("R8:R219") will be keep changing depending on the type of item selected.

So I believe that by using VBA i can obtain the result faster. =)

This is very easy to do with standard CF. But ok. Check this out... http://msdn.microsoft.com/en-us/libr...ffice.15).aspx


Sent from my iPad using Tapatalk

Thanks coolblue,

I would elaborate more into my problem, this is what contain in Cell N

Please Login or Register  to view this content.

and this is what contain in cell P

Please Login or Register  to view this content.

where there is no selection of item in cell B12 and D12, both cell N and P would appear as #REF! error, and when the user wish to print the list out, the #REF! error retain and I was thinking of using cell R as a reference cell (as the final result is being tabulated in cell R) to change the font color of cell N and P.

Can this be applied by using standard CF as well?

Upload your spreadsheet and I'll have a quick look at it...


Sent from my iPhone using Tapatalk

My spreadsheet look something like this with a longer list

Font.xlsx

I made the colour red, not 2, so you can see it but you can change it in the conditional format.
Using merged cells in your table body is a very bad idea by the way...

I wish not to include the merged cell as well, but im in a rush and im editing based on the company existing formatting for the past.

But thank you very much for pointing it out! =)

Can you access the CF ok? Just use the shortcut Alt-O-D


Sent from my iPhone using Tapatalk