Results 1 to 6 of 6

Conditional Format not completely applying until some cell input

Threaded View

dan1402 Conditional Format not... 07-23-2010, 12:11 PM
dan1402 Re: Conditional Format not... 07-27-2010, 02:45 PM
peterjuhnke Re: Conditional Format not... 07-30-2010, 08:12 AM
masteff Re: Conditional Format not... 07-27-2010, 03:23 PM
dan1402 Re: Conditional Format not... 07-29-2010, 05:45 PM
martindwilson Re: Conditional Format not... 07-29-2010, 06:56 PM
  1. #1
    Registered User
    Join Date
    07-11-2010
    Location
    Croatia
    MS-Off Ver
    Excel 2007
    Posts
    7

    Conditional Format not completely applying until some cell input

    Hy, I have one problem, probably small problem for someone but big for me.

    I do not understand, why is conditional formating not applying on cell in my document completely. There is color change every time on dropdown select, but Number format is not changing until i alterate some cell in document.

    Also, i noticed, after some cell change it changes three times on my action, one time for each input, and color and format number on big cell, but after that not any more.

    I need answer if is that normal and how i can accomplish to change automaticly after dropdown change if i can at all.

    Greetings from Croatia, sample file in in attachment.

    P.S. #1 I can not use macro because settings must be on High and i can not change that.
    P.S. #2 Sorry for bad English
    Attached Files Attached Files

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