condition format for surrounding cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need help, I have column A the have 3 conditional format that is color coded
depending value, I would like to have columns B, C, D,E (which are text) that
could changes to the same color as column A when that changes. If anyone
could help that would be greatly appriciated.
 
Hi
try something like the following:
- select A1:E1
- in the conditional format dialog enter a formula such as
=$A1="condition1"

--
Regards
Frank Kabel
Frankfurt, Germany

"little rusty with excel" <little rusty with
(e-mail address removed)> schrieb im Newsbeitrag
news:[email protected]...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel conditional formatting with Weeknum 4
Excel VBA 1
conditional formatting 1
Conditional formatting, based on a different cell? 3
Conditional Formatting 3
Conditional Format Range of Cells 3
CONDITIONAL FORMATING: 3 COLOR SCALE REFERENCED TO A DIFFERENT CEL 1

Back
Top