Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108432

Re: Help needed: Conditional Formatting for 3 columns, any two of which must have data

From Claus Busch <claus_busch@t-online.de>
Newsgroups microsoft.public.excel.programming
Subject Re: Help needed: Conditional Formatting for 3 columns, any two of which must have data
Date 2016-01-08 10:02 +0100
Organization A noiseless patient Spider
Message-ID <n6ntq2$t3d$1@dont-email.me> (permalink)
References <67f4632a-e0e7-47e3-a09f-ed76d3bd90a1@googlegroups.com>

Show all headers | View raw

Hi Pete,

Am Thu, 7 Jan 2016 21:53:00 -0800 (PST) schrieb pete:

> I have 3 columns, A, B, and C.  Each will accept input of exactly 6 alphanumeric characters.  Two of the three must be populated.  
> 
> The Conditional Formatting is used to highlight columns which are not compliant.

select A1:C to the end
Conditional Formatting:

=SUM(LEN(TRIM($A1:$C1)))<12


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Help needed: Conditional Formatting for 3 columns, any two of which must have data pete <pegelo@gmail.com> - 2016-01-07 21:53 -0800
  Re: Help needed: Conditional Formatting for 3 columns, any two of which must have data Claus Busch <claus_busch@t-online.de> - 2016-01-08 10:02 +0100
    Re: Help needed: Conditional Formatting for 3 columns, any two of which must have data pete <pegelo@gmail.com> - 2016-01-08 05:51 -0800
  Re: Help needed: Conditional Formatting for 3 columns, any two of which must have data Claus Busch <claus_busch@t-online.de> - 2016-01-08 10:09 +0100

csiph-web