+ Reply to Thread
Results 1 to 3 of 3

Conditional Formatting - Changing Row formatting from single cell input

  1. #1
    Registered User
    Join Date
    03-12-2007
    Posts
    3

    Conditional Formatting - Changing Row formatting from single cell input

    Hello again,

    Hopefully another easyish question.

    I have a worksheet that i wish to perform some conditional formatting on.

    There is some descriptive text in cells A1 and A2. From A3-A10 there are some cells where any number of them could be marked off with an 'X'.

    If any of the cells from A3-A10 contain an X, I would like the colour of the row from A1 through to A10 to change to say, red.

    This is the same for row B, C, D etc.

    I have managed to get single cells to change, but am struggling with rows. I am also struggling with the fact that it could be an X in any number of cells, rather than saying cell A5=X, for example.

    Hope this makes sense, any help would be gratefully appreciated.

    Many thanks,

    Mark

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    Select the whole range, e.g. A1:Z10 and use conditional formatting formula is option with formula

    =COUNTIF(A$3:A$10,"x")

    choose red format > OK

  3. #3
    Registered User
    Join Date
    03-12-2007
    Posts
    3
    thanks very much

+ 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