Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2001
    Location
    Lawrence, Kansas, USA
    Posts
    202
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Format Row (Excel 2007)

    I would like to set up a conditional formatting to format a whole row based on one cell value in that row. For example, if "OK" is in the cell C3, I would like all of row 3 to have a different format. I'm stumped. Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Conditional Format Row (Excel 2007)

    Select row3
    Format - conditional formatting...
    Formula is:
    <pre>=$C3="OK"</pre>

    [Format]
    Set the desired format
    [ok][ok]

    Steve

Posting Permissions

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