+ Reply to Thread
Results 1 to 2 of 2

Conditional formatting

  1. #1
    stephen.leonard3@ntlworld.com
    Guest

    Conditional formatting

    Hi
    I am trying to create a holiday planner for the GP practice where I
    work, and have have inserted a number for available appointments a GP
    has in cell B1, but when they go on holiday I insert a H in cell A1 and
    it turns yellow, and in cell B1 I want it to change to overide the
    number of appointments by placing a 0 and also turning it yellow, I can
    get the colour to change but not the number, I have used formula is:
    =IF(A1="H",0) but it is not working, it works as a basic if function
    but not in conditional formatting, please help.

    Thank You

    Pam


  2. #2
    MyVeryOwnSelf
    Guest

    Re: Conditional formatting

    > I am trying to create a holiday planner for the GP practice where I
    > work, and have inserted a number for available appointments a GP
    > has in cell B1, but when they go on holiday I insert a H in cell A1 and
    > it turns yellow, and in cell B1 I want it to change to override the
    > number of appointments by placing a 0 and also turning it yellow, I can
    > get the colour to change but not the number, I have used formula is:
    > =IF(A1="H",0) but it is not working, it works as a basic if function
    > but not in conditional formatting, please help.


    What I'd suggest is to do two things to get the result you want.

    First, use conditional formatting as you already have done.

    Second, use a basic "if" function in B1; for example,
    =IF(A1="H",0,5)

+ 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