Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I create a conditional format in a cell using a value from an.
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? |
#2
|
|||
|
|||
Yes! However, conditional formatting cannot be evaluated based on
cells in different tabs or spreadsheets. |
#3
|
|||
|
|||
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 "Dave O" wrote: Yes! However, conditional formatting cannot be evaluated based on cells in different tabs or spreadsheets. |
#4
|
|||
|
|||
Select the cell(s) in which you want the conditional formatting
Choose FormatConditional 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: =$A250 Click the Format button, and select the formatting for the cell Click OK, click OK thrasher wrote: 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? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
How do I create a bulleted list text format inside cell? | Excel Discussion (Misc queries) | |||
Can you conditional format based on information in cell comments? | Excel Worksheet Functions | |||
How do I do conditional format based on a cell with a formula? | Excel Worksheet Functions | |||
GET.CELL | Excel Worksheet Functions |