Hide and Unhide text

I have a range of cells that are conditionally formatted based on their value. The only conditional formatting is the fill color. So if A1=0, fill is White, if A1<.92, fill is green, if A1>.93 and < 1.05, fill is gray and if A1>1.06, fill is blue.

What I would like to be able to do is hide or unhide the text at will, with a key combination or a button. Essentially click a button and have the text color match the fill color, click another button and have the text revert to black.

I tried to write a macro that would match the above conditions to have the text color match the cell color, but it seems I can’t “regular” format the text if there is conditional formatting already applied to the cell. I could conditional format the text as above, but then I am unable to toggle back and forth between hide and unhide.

If someone knows of a way to hide and unhide the text I would be very thankful

See the attached example

Regards

It just uses Conditional Formatting. For each condition, there are two CF conditions; one that just tests for the original condition and formats the background colour and the other that also checks cell K1. If K1 is non-blank, it applies the original format and formats the font the same colour as the background colour.

If you want a button, you could make it toggle the content of cell K1

Regards

You're welcome.

Regards