Results 1 to 2 of 2

Thread: Formatting linked sheets

  1. #1

    Formatting linked sheets



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I HAVE A WORK BOOK WITH 3 SHEETS, THAT ARE ALL LINKED.

    HOWEVER I NEED TO KNOW HOW I CAN DO THE FOLLOWING.

    I WANT TO CONDITIONAL FROMATE THE FOLLOWING SHEET AND FIELDS SEE BELOW ONLY IF THE FIELDS ON THE OTHER SHEET CONTAIN NO BLANKS.

    Noncontracted call log cell rance c2-c100 formate green if on non contracted call out Log Dispatch e3-e100 contain no blanks

  2. #2
    Conjurer WizzardOfOz's Avatar
    Join Date
    Sep 2013
    Location
    Australia
    Posts
    184
    Articles
    0
    Conditional formatting, new rule, "Use a formula to determine which cells to format" and
    Formula is
    =ISBLANK('log Dispatch'!e3:e100)

    or
    =NOT(ISBLANK('log Dispatch'!e3:e100))
    depending which you want
    Last edited by WizzardOfOz; 2014-10-09 at 09:39 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •