+ Reply to Thread
Results 1 to 5 of 5

Conditional formatting with formula

  1. #1
    Registered User
    Join Date
    02-26-2020
    Location
    lincoln, england
    MS-Off Ver
    2016?
    Posts
    3

    Question Conditional formatting with formula

    Going mad trying to format a spreadsheet that details availability of invigilators, where each row is a different time slot.
    I have a column of how many people I need and a column of how many people are available. I want to highlight the cells where I have LESS people available then I need. I know I can easily do that as a highlight cell rule, but that only works for one cell at a time... Is there a way I can apply this rule to the whole column?
    Thanks in advance - it may be a super obvious fix but I'm not tech savvy enough for this, despite what they say about the younger generations... :)

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    6,994

    Re: Conditional formatting with formula

    Attach a sample file, details at the top of the forum in a yellow background.
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    02-26-2020
    Location
    lincoln, england
    MS-Off Ver
    2016?
    Posts
    3

    Re: Conditional formatting with formula

    There are no formulas or anything in it, not really a useful sample. Ignore the colour coding. It's Columns C and D.
    Attached Files Attached Files

  4. #4
    Forum Moderator Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,418

    Re: Conditional formatting with formula

    Select C2:E11 or a larger range and use
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    as CF. Format as required
    You really don't have to give me rep points for moderating. It's part of the job. Keep rep points for those who find solutions

  5. #5
    Registered User
    Join Date
    02-26-2020
    Location
    lincoln, england
    MS-Off Ver
    2016?
    Posts
    3

    Re: Conditional formatting with formula

    Thanks, knew it'd be a simple solution, thought I'd already tried that!!

+ 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