Home > OS >  Excel on how to realize the value in the cell below is equal to a value, and not said
Excel on how to realize the value in the cell below is equal to a value, and not said

Time:11-02

Did excel2013 can set the effect of this method, or vba to also go


CodePudding user response:

Where is the great god

CodePudding user response:

Can use the combined center option 2 times, and then manually add on line

CodePudding user response:

Conditional formatting can set the font color is the same as the background

CodePudding user response:

Upstairs is

Set up two conditional formatting
A set if the value is equal to a cell, the text color as background, cell to form;;;
A set if the value is not equal to a cell, borders on the set
  • Related