Results 1 to 6 of 6

Conditional Formatting with array formula

Threaded View

  1. #1
    Registered User
    Join Date
    09-19-2008
    Location
    Gloucester, MA
    MS-Off Ver
    Excel 2016
    Posts
    62

    Conditional Formatting with array formula

    I read somewhere that Conditional Formatting evaluates custom formulas as though they were array formula, so you may use array formulas in format conditions. You do not enter them with Ctrl+Shift+Enter in the CF dialog as you normally do in worksheet cells. Excel will always treat a custom formulas in CF as an array formula, even if it is not one.

    When I copied my formula with an array to the CF dialog box and clicked Ok, the conditional formatting didn't work. It only worked for the first column of data. Does anyone have experience with this?

    What I am trying to do is strike out the rows of data that are not the latest ver. Only the first column was formatted correctly. Is there a way around this? Thanks.
    Attached Files Attached Files
    Last edited by kadams99; 07-03-2013 at 11:48 AM.

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