@alex2476
As @Hans Vogelaar has already said, there's not a formula-based way to do what you're asking, especially if the formatting you're wanting to copy with the formula is random or arbitrary.
However, if the colors/background/etc --the formatting -- is not arbitrary, but very systematic, i.e., if you're original cell's format is created following rules in the Conditional Formatting way, then you could just use the same rules and Conditional Formatting.
And if I could be an Excel consultant for a moment, and ask a question I'd be sure to ask were we meeting face-to-face, that question would be "Why?" Asked more completely, "Why are you wanting to do this in the first place?"
Adding more complete context to the question, having viewed many many spreadsheets over the course of recent years, unless formatting is used consistently and in a rule-based fashion, it can make a spreadsheet look chaotic. Even used consistently and in a rule-based fashion, excessive use of text color, bold and varied fonts, background color, etc, can draw attention to itself in a way that distracts from the functionality that people usually want, and can make ongoing maintenance a pain.
So that's why I ask. You don't have any obligation to answer, of course, but I do think it's a legitimate question, meant to help, and based on experience helping others design spreadsheets.
