Text Color Based on Cell Color

  • i am using the gradient conditional format to set the cell color based on cell value but i need the text color to match the cell color. is there a way to do this with vba or standard built-in function?

    thanks for the help.

  • Re: Text Color Based on Cell Color

    If the text color matches the cell color, then the text would not be visible, correct? In that case, it would be easier to change the number format, rather than the color. A custom format of:
    will prevent anything from being displayed in the cell.

    Best Regards,
    Luke M
    "A little knowledge is a dangerous thing."

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!