News
22h
How-To Geek on MSN5 Excel Custom Format Tricks You Didn’t Know You NeededQuick LinksHide Cell ValuesReplace Zeros With a DashTurn Values to Text Based on a ConditionColor Numbers Based on Their ...
A ‘Format as Table’ menu will pop up. This will give you a drop-down of table formatting options. I chose to use the middle green format in the Light category. Click for larger image.
Finally, it’s time to create the conditional format rule that fills alternating groups in the Excel Table: Select the data, B3:F13. (Don’t include the column of consecutive values in column H.) ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results