+ Reply to Thread
Results 1 to 2 of 2

Whole column conditional formatting.

Hybrid View

  1. #1
    Registered User
    Join Date
    06-20-2012
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    1

    Whole column conditional formatting.

    I have two columns of figures. I would like to apply conditional formatting to the figures in column 'B' when they fall below the figures in column 'A' I need this to apply to the whole worksheet. 'B1' less than 'A1' and so on down the sheet?
    Is there a quick way to do this without having to enter individual formulae for each row which would take forever over nearly 1000 rows.
    This sheet is to show when stock falls below a pre-defined minimum in column 'A'

  2. #2
    Registered User
    Join Date
    06-14-2012
    Location
    Cambridge, UK
    MS-Off Ver
    Excel 2013
    Posts
    48

    Re: Whole column conditional formatting.

    Highlight column B and create a new conditional formatting rule and use the following formula

    =IF(B1<A1,TRUE,FALSE)
    <--- Please click the star to say thank you

+ 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