+ Reply to Thread
Results 1 to 8 of 8

Conditional formating depending on value

Hybrid View

  1. #1
    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

+ Reply to Thread

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. 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