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
Bookmarks