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?
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.