# Conditional format depends on other cell value: Impossible ?

#### mrchonginhk

##### Well-known Member
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.

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.
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)

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

=\$A\$1=TRUE

and set the formatting.

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.

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 ??

Re: Conditional format depends on other cell value: Impossib

mrchonginhk said:
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)

Replies
1
Views
138
Replies
1
Views
563
Replies
2
Views
273
Replies
14
Views
632
Replies
8
Views
278

1,207,390
Messages
6,078,206
Members
446,321
Latest member
thecachingyeti

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back