conditional formatting

  • Thread starter Thread starter esslinger
  • Start date Start date
E

esslinger

Is it possible to format one cell dependent on the value
of a different cell?
 
One way:

Select B1. Choose Format/Conditional Formatting...

CF1: Formula is =A1>10
Format1: Pattern/Red


will cause B1 to have a red background when A1 is > 10.
 
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

Conditional Formatting with VBA 4
Excel Macro to automatically go to the right of the last colored cell 0
conditional format fails when copied 1
Excel Highlighting duplicates 0
Conditional Formatting 4
Excel Conditional Formatting 1
Excel Conditional Formatting Removal 7
Conditional format if difference in cell values greater than 0.50% 1

Back
Top