Can I create a conditional format in a cell using a value from an.

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

Guest

I am trying to conditionally format a cell in a column based on a condition
in a different cell in that column. Can this be done?
 
Yes! However, conditional formatting cannot be evaluated based on
cells in different tabs or spreadsheets.
 
How do I do this? I would like a cell in a column to be formatted based on a
condition of a different cell in that column
 
Select the cell(s) in which you want the conditional formatting
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type a formula that refers to the cell you
want to check. For example, if the active cell is in row 2,
and you want to check the value in column A: =$A2>50
Click the Format button, and select the formatting for the cell
Click OK, click OK
 
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

Help needed 0
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Excel VBA 1
Excel conditional formatting with Weeknum 4
Excel Highlighting duplicates 0
Conditional formatting, based on a different cell? 3
Conditional Formatting - Excel 2003 2
Conditional Format Range of Cells 3

Back
Top