How in EXCEL values in multiple cells simultaneously by a number plus * it?
Users questions: Also can not be achieved when a value exceeds a certain value, automatically changes (such as color or font)
Experts answer: can be. As follows: In a blank cell, enter the desired number of plus or minus review select the desired first cell Press the Ctrl key select the desired cell Edit Paste operation plus or minus OK. Complete the operation. Format Conditional Formatting formula or cell value ... ... Format ... ... OK OK. Complete color or font settings.