Results 1 to 3 of 3

formatting range based on cell

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-22-2006
    MS-Off Ver
    2010
    Posts
    201

    formatting range based on cell

    hi all

    I have a spreadsheet with a range of data in A1:T400

    What i would like to do is loop thru the range and for each row, if the value in B1:B400 is either "remove","delete","wrong" or "error" highglight the row A:T as red

    Hope someone can help.

    Thanks
    Luce
    Last edited by NBVC; 08-04-2010 at 01:02 PM.

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