conditional formating which reacts on nerby cells

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

Guest

Is it possible to change formating of values in column A depending on value
in column B ?

For example i want to highlight value entered in cell A1 in red if Cell B1
value is 1 and highlight in blue if B1 is 2
 
Select your cells, with A1 as the active cell. In the CF dialog, select formula, and use a formula

=B1=1

and set the format to red fill.

For the second condition, set the formula to

=B1=2

and set the format to blue fill.

HTH,
Bernie
MS Excel MVP
 
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 Help 1
Conditional Formatting 1
Conditional format a column based on value in a different column 3
conditional format on column based on cell value 2
Conditional Formatting 1
Conditional Formatting - Formula to fill cell using >% 2
Conditional Formatting on empty cells 6
condition formatting involving formula 2

Back
Top