Results 1 to 10 of 10

change row color after filling one cell

Threaded View

  1. #1
    Registered User
    Join Date
    09-05-2010
    Location
    italy
    MS-Off Ver
    Excel 2018
    Posts
    63

    change row color after filling one cell

    Hi, I attach a file to better describe what I need.

    Column A: either one of the two following values, "P" (= pending) or "C" (=canceled)
    Example:

    If A1=P, cell A1:G1 will stay White.
    If A1=C, cell A1:G1 will change color to Green.

    I hope I could explain what I need.
    Don't hesitate to ask me anything is not clear.

    Thank you,

    Carlo
    Attached Files Attached Files
    Last edited by kghisla; 09-26-2010 at 06:50 PM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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