Results 1 to 8 of 8

Conditional formatting with formula referencing range in different cell

Threaded View

  1. #1
    Registered User
    Join Date
    10-16-2008
    Location
    The Netherlands
    Posts
    15

    Conditional formatting with formula referencing range in different cell

    Hi,

    It's probably pretty simple, but I'm already breaking my head over it for a couple of hours now.

    I want to set a conditional format to cell A1 with a value in cell P1
    When the value in P1 is between 0 and 10 the conditional value in P1 should be set.

    Note
    cell A1 is also set with a conditional format to put a border around it when there's a value in A1 (cellvalue is not equal to " ")
    So the formula referencing P1 would be a second condition.

    Thanks!
    Last edited by NBVC; 10-21-2008 at 04:35 PM.

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