Conditional Cell formatting

[Cindyrella]

Can you format a cell using some variation of the IF condition? Specifically, if I place an "X" in a cell can I am make that cell and the two cells to its left become highlighted in light gray? And, of course, if I remove the X the cells would return to the previous "no highlight"?

 

[Mark W.]

Yes, select the 3 cells (e.g., A1:C1) and setup a Formula Is condition using the formula, =$C1="X".

 

[Al Chara]

Take a look at conditional formatting. Add the following constraints:

Select all the cells
Go to FORMAT|CONDITIONAL FORMATTING
Cell value is equal to ="x"
Click Add
Formula is =INDIRECT(ADDRESS(ROW(),COLUMN()+1))="x"
Click Add
Formula is =INDIRECT(ADDRESS(ROW(),COLUMN()+2))="x"

Then click the format button, select the Patterns tab, and then select your color.

_________________
Kind regards,<font size="5">^{<span style="text-decoration: overline">AL</span>}<u>_CHARA</u></font
This message was edited by Al Chara on 2002-08-03 16:48

 

[eliW]

On 2002-08-03 16:31, Mark W. wrote:
Yes, select the 3 cells (e.g., A1:C1) and setup a Formula Is condition using the formula, =$C1="X".

Mark,
Your solution will be good for "X" inputs in column C, but how can it be done for "X" in any other column - say F1 which will highlight D1:F1 only ???
Eli

 

[Mark W.]

=OR(C1="X",B1="X",A1="X")