How to do a conditional formatting based on an adjacent cell

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

Guest

I want to conditionally format a cell if a different cell has contains
certain data. I only know how to do this based on the selected cells
contents. Can anyone help?
 
Format / CF / Change 'Cell Value is' to 'Formula is' and then use normal
formulas with cell references.
 
To CF A1 when B1 is equal to "confused".......

Select A1 then Format>CF>Formula is:

=B1="confused"

Pick a format and OK your way out.

Gord Dibben 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

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
conditionally formatting cells based on other cells 1
Excel Conditional Formatting 1
conditional formatting on formua with another cell 2
Conditional formating 1
Conditional formatting, based on a different cell? 3
How do I format a cell based on conditions in five different cells 1
Conditional formatting flag 1

Back
Top