PC Review


Reply
Thread Tools Rate Thread

Conditional Formatting - indirect

 
 
AA2e72E
Guest
Posts: n/a
 
      18th Feb 2010
How can I format column B based on the true|false result of a formula
applying to column E?

Thanks.
 
Reply With Quote
 
 
 
 
Jacob Skaria
Guest
Posts: n/a
 
      18th Feb 2010
For example; select Column C and then from menu Format>Conditional
Formatting>Select 'Formula Is'

=E1=TRUE

and select a color...


--
Jacob


"AA2e72E" wrote:

> How can I format column B based on the true|false result of a formula
> applying to column E?
>
> Thanks.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting using indirect reference and "AND" kapstadt07@gmail.com Microsoft Excel Discussion 0 17th Sep 2008 05:55 PM
Conditional formatting using indirect reference and "AND" kapstadt07@gmail.com Microsoft Excel Discussion 0 17th Sep 2008 05:54 PM
Conditional Formatting: Logical AND fails to work with INDIRECT(.. Hamish Microsoft Excel Worksheet Functions 5 15th May 2008 04:54 PM
Indirect in Conditional Formatting Tommy Boy Microsoft Excel Programming 7 20th Dec 2007 12:14 PM
Multiple conditional formatting with data validation indirect lists zencherry Windows XP 0 3rd Mar 2007 11:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:38 AM.