Results 1 to 3 of 3

Thread: Conditional formatting problems

  1. #1
    Neophyte Igorod's Avatar
    Join Date
    Oct 2012
    Location
    York, Pennsylvania, United States
    Posts
    2
    Articles
    0

    Conditional formatting problems



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

    I have a spreadsheet with values in column A reflecting a ticket number, values filled out in columns B through H, and then responses that get completed after talking to a user in column I. I'd like to set up conditional formatting so that the cell in column I turns red, if the cell in column I is blank and the respective cell in column A is filled out.

    A B-H I
    12345 Contacted user.(not red)
    12345 (red)
    (not red)

  2. #2
    Setup new rule and use formula below. Don't for get to set the fill color to red on the format


    =AND(A1>0,I1="")

  3. #3
    Neophyte Igorod's Avatar
    Join Date
    Oct 2012
    Location
    York, Pennsylvania, United States
    Posts
    2
    Articles
    0
    Well I'll be darned, I was trying all kinds of crazy things and it was as simple as that. Works perfectly, thanks!

Posting Permissions

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