Conditional Formatting based on adjacent cell value

Conditional Formatting based on adjacent cell value

Post by QmlsbCBNZW » Thu, 13 Dec 2007 05:22:03


I want to highlight cell A6 if cell B6 has the value "Yes". How do I do it?
 
 
 

Conditional Formatting based on adjacent cell value

Post by TWFyY2Vsb » Thu, 13 Dec 2007 05:30:03

Hi

Format | Conditional Format

Change to Formula is and use:

=B6="Yes"

format as you need.

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Bill Meacham" escreveu:

 
 
 

Conditional Formatting based on adjacent cell value

Post by QmlsbCBNZW » Thu, 13 Dec 2007 05:34:01

That works. Thanks!
 
 
 

Conditional Formatting based on adjacent cell value

Post by TWFyY2Vsb » Thu, 13 Dec 2007 05:38:01

thanks for the feedback


--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"Bill Meacham" escreveu: