You are viewing a single comment's thread from:

RE: Excel Dynamic Conditional Formatting Tricks

in #excel • 5 years ago (edited)

For filling every other row: =AND(ISEVEN(MOD(ROW(A2:D2);2));NOT(ISBLANK(A2)))

For dynamic sum cell border: =AND(NOT(ISBLANK(D2));ISBLANK(D3))
- Branislav

This comment was made by a guest account using @steempress. Rewards will be sent to the user once they have a Steem account

5 years ago in #excel by
$0.24
  • Past Payouts $0.24, 0.00 TRX
  • - Author $0.12, 0.00 TRX
  • - Curators $0.12, 0.00 TRX
3 votes
Reply 2
Sort:  
  • Trending
    • [-]
     5 years ago 

    ok

    [-]
     5 years ago 

    Hello steempress-test!

    Congratulations! This post has been randomly Resteemed! For a chance to get more of your content resteemed join the Steem Engine Team

    Coin Marketplace

    STEEM 0.16
    TRX 0.12
    JST 0.026
    BTC 57387.61
    ETH 2518.18
    USDT 1.00
    SBD 2.31