How to copy the color that is based on conditional format rule from one cell into another?

Try something like this:

Please Login or Register  to view this content.

You could apply this custom Number Format: ;;;
In the illustration, A1:A7 contain numbers 1-7, but APPEAR to be EMPTY! USE CAREFULLY!!! If you forget you did this, it can drive you nuts.
Untitled.png

Please click the Add Reputation star below any helpful posts, and if you have your answer, mark your thread as SOLVED (Thread Tools up top). Thanks!-Lee

This would make all the numbers invisible:

Please Login or Register  to view this content.

Originally Posted by JET2011

Leelnich - Looks like a nice simple solution but I do not have that option on my dropdown.

Select your cells, then right-click and select Format Cells.... Select the Number tab. Now select Custom, then go up to the Type: box, delete whatever is in it, and type ;;;. Then click OK

You're welcome and thanks for both the rep and the compliment!