Hi,
Using conditional formatting, is it possible to scale the font color instead of the cell color?
And if so how?
Thanks.
Hi,
Using conditional formatting, is it possible to scale the font color instead of the cell color?
And if so how?
Thanks.
The built in CF will only do fill colour.
You can use VBA to replicate.
The example applies 3 colour scale Red>Yellow>Green
It uses the Change event to trigger the refresh.
worksheet code
![]()
Please Login or Register to view this content.
If you want a different CF style then just record the application of the CF and modify the above code.![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks