Conditional format depends on other cell value: Impossible ?

[mrchonginhk]

Suppose I have a cell in A1 which is either "True" or "False"

Is it possible to condition format the text A2:B4 so that is A1 = True, they turned into blue and if false they turn into red.

The range A2:B4 has already has text in every single cell.

Is this impossible ? I wish to do it without VBA. Thanks.

 

[ken2step]

Re: Conditional format depends on other cell value: Impossib

Select range A2:B4
Then go to conditional format and make it "formula is"
enter =$A$1=1

you will need to coerce your formula in A1 to change your True or False to a 1 or 0. Example: =--(your formula)

 

[P Sitaram]

Select A2:B4. Goto Conditional Formatting. Choose Formula Is and enter the formula:

=$A$1=TRUE

and set the formatting.

 

[rs2k]

In conditonal format use
condition 1
Formula is =$A$1=TRUE (then choose your format)
condition 2
Formula is =$A$1=FALSE (then choose your format)

Colin.

 

[mrchonginhk]

Re: Conditional format depends on other cell value: Impossib

Thanks.

How about if I need it to change color

(Case 1) A1 & A2 both are TRUE
(Case 2) either A1 or A2 is TRUE

How to set the formula in both cases ??

 

[Brian from Maui]

Re: Conditional format depends on other cell value: Impossib

Thanks.

How about if I need it to change color

(Case 1) A1 & A2 both are TRUE
(Case 2) either A1 or A2 is TRUE

How to set the formula in both cases ??

=(A1="TRUE")*(A2="TRUE")

=OR(A1='TRUE",A2="TRUE)