Results 1 to 5 of 5

conditional formatting

Threaded View

freeriding conditional formatting 11-23-2018, 03:29 PM
FoxSeaLady Re: conditional formatting 11-23-2018, 03:58 PM
etaf Re: conditional formatting 11-23-2018, 04:02 PM
freeriding Re: conditional formatting 11-24-2018, 04:54 AM
AliGW Re: conditional formatting 11-24-2018, 05:17 AM
  1. #1
    Forum Contributor
    Join Date
    09-21-2015
    Location
    Alexandria
    MS-Off Ver
    2013
    Posts
    106

    conditional formatting

    Hallo!

    I have to columns.
    The one contains numbers or blanks or zeros.
    The other needs to be formatted with color, depending on these rules:

    if the first column contains a number other than 0, then it must be red
    if the first column contains a number equal to zero, or is blank, then it must be blank-without color
    if the second column contains the word 'yes', then, whether red or without color before, it must become blue.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  2. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  3. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  4. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  5. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  6. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 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