Results 1 to 20 of 20

Array set for Conditional Formatting

Threaded View

  1. #11
    Banned User!
    Join Date
    02-05-2015
    Location
    San Escobar
    MS-Off Ver
    any on PC except 365
    Posts
    12,168

    Re: Array set for Conditional Formatting

    in range type: 1,2,1,-2,0,1,2,2,1,0 all < 3 you will see red. if any of cells will be empty range will lost color. if any of values willl be < 3 - range will lost color. enough ONE cell with number >=3 or ONE empty cell to clear range from color.

    but basically you did not tell what exactly you want to achieve
    Attached Files Attached Files
    Last edited by sandy666; 03-30-2016 at 06:42 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting with Array Formulas
    By zmster2033 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-27-2015, 02:38 PM
  2. Using an array and conditional formatting
    By seangun in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-18-2014, 07:57 AM
  3. [SOLVED] Conditional formatting with IF/AND/OR (array's?)
    By anghicole in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-06-2013, 04:17 AM
  4. [SOLVED] Conditional Formatting with array formula
    By kadams99 in forum Excel General
    Replies: 5
    Last Post: 07-03-2013, 11:48 AM
  5. Conditional Formatting in an array while using edate
    By svalentine91 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-30-2013, 05:36 PM
  6. Excel 2007 : Conditional formatting, searching array
    By astillar in forum Excel General
    Replies: 1
    Last Post: 06-27-2010, 01:56 AM
  7. Conditional formatting based upon array
    By RocketMan in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-16-2006, 12:10 PM

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