+ Reply to Thread
Results 1 to 2 of 2

cell back ground color change upon cell results

  1. #1
    Forum Contributor
    Join Date
    05-22-2007
    Location
    Laguna Beach, CA
    MS-Off Ver
    MS Office 2024
    Posts
    145

    cell back ground color change upon cell results

    Two things:

    resolved: 1. I like to be able to change the cell's background color (yellow) if the cell =0 and have no color if the cell is >0.....contents will be $.

    2. if the cell is 7/2010 the cell next to it would read 7 or 8/2011 and 8, etc. and the 7 or 8 has a number value so I can divide other cells by it.

    Example: 14 / 7 (7/2011) or 24 / 8 (8/2011).

    Thanks.

    IG

    Edited: I figured out how to be #1.
    Last edited by InvGrp2; 07-10-2011 at 07:42 PM.

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    Win10/MSO2016
    Posts
    12,971

    Re: cell back ground color change upon cell results

    If A1=7/2011, then B1: =Month(A1) -> 7
    Ben Van Johnson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1