Results 1 to 8 of 8

Conditional formating depending on value

Threaded View

kuzcomerlin Conditional formating... 08-03-2015, 12:51 PM
Mazzaropi Re: Conditional formating... 08-03-2015, 01:16 PM
kuzcomerlin Re: Conditional formating... 08-04-2015, 11:49 AM
newdoverman Re: Conditional formating... 08-03-2015, 02:24 PM
FDibbins Re: Conditional formating... 08-04-2015, 11:54 AM
kuzcomerlin Re: Conditional formating... 08-06-2015, 03:57 PM
FDibbins Re: Conditional formating... 08-06-2015, 04:00 PM
newdoverman Re: Conditional formating... 08-06-2015, 04:46 PM
  1. #4
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: Conditional formating depending on value

    Welcome to the forum.

    Select the cell with the formula =IF(K31>24,"FULL","AVAILABLE")

    In Conditional Formatting, New Rule, Use formula.... enter this formula:
    I have used M1 for the cell with the formula for this example:
    Formula: copy to clipboard
    =M1="FULL"


    Choose the formatting that you want for full. Click OK, Apply and click OK.

    With M1 still selected enter the following in Conditional Formtting, New Rule, Use formula...
    Formula: copy to clipboard
    =M1="AVAILABLE"


    Choose the formatting for AVAILABLE. CLICK, OK, APPLY, OK.

    In this very simple example (only 2 cells used) change the value in K31 and see the colour change in M1
    Attached Files Attached Files
    Last edited by newdoverman; 08-03-2015 at 02:27 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 10-15-2014, 08:32 AM
  2. Replies: 5
    Last Post: 03-14-2014, 04:03 AM
  3. Replies: 4
    Last Post: 01-23-2014, 10:14 AM
  4. Replies: 4
    Last Post: 07-08-2013, 06:29 AM
  5. Adding conditional formating depending on user input.
    By haitham1984 in forum Excel General
    Replies: 1
    Last Post: 11-03-2008, 09:31 PM
  6. Replies: 6
    Last Post: 08-14-2006, 05:00 PM
  7. [SOLVED] conditional formating on rows & cols depending on one cell
    By bandy2000 in forum Excel General
    Replies: 1
    Last Post: 03-07-2006, 07:50 PM

Tags for this Thread

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