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

Re: Help Rquired (Aug'16)

From	Claus Busch <claus_busch@t-online.de>
Newsgroups	microsoft.public.excel.programming
Subject	Re: Help Rquired (Aug'16)
Date	2016-08-04 07:34 +0200
Organization	A noiseless patient Spider
Message-ID	<nnuk4a$e7a$1@dont-email.me> (permalink)
References	<1dcbdc69-48f6-4ab2-a0c5-d8345db7f8ff@googlegroups.com>

Show all headers | View raw

Hi,

Am Wed, 3 Aug 2016 21:46:12 -0700 (PDT) schrieb Akash Maheshwari:

>   Room Category | Guest Name | Plan
> 1. 
> 2.
> 3.
> 4.
> 5.
> 
> If I mention OPP in the cell under Room Category the color of the cell changes to Green automatically as I had put conditional formatting. What I want is if the cell color of Cell under Room Category is getting changed becoz of conditional formatting then the cell under Guest Name & Plan should also change in same color.

select your table from A2:C and last row and use in CF the formula:
=$A2="OOP"


Regards
Claus B.
-- 
Windows10
Office 2016

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

Thread

Help Rquired (Aug'16) Akash Maheshwari <maheshwari.akash@gmail.com> - 2016-08-03 21:46 -0700
  Re: Help Rquired (Aug'16) Claus Busch <claus_busch@t-online.de> - 2016-08-04 07:34 +0200

csiph-web