Conditional formatting based on a cell

[kcgojnur]

Hello -

I have several columns that need to be grayed out if the header = "False". So for example

F5:P5 indicates either true or false
F6:P10 has rates.

So if F:5 indicates false I want cells F6:F10 to be grayed out.

Is there a faster way to do this then to do conditional formatting each column, one at a time?

 

[mrhstn]

Highlight F6:P10 and in conditional formatting use formula

=F$5

or

=F$5="false"

 

[kcgojnur]

Highlight F6:P10 and in conditional formatting use formula

=F$5

or

=F$5="false"

Doesn't seem to work. I'm looking to conditional format if a column indicates true nothing should happen but if a column marks false the data below the false should be grayed. Carrier A is cell F5. I highlighted F6 through P10 and used =F$5="False", but nothing happened. I also made sure to clear any existing conditional formatting.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Carrier A
[/TD]
[TD]Carrier B
[/TD]
[TD]Carrier C
[/TD]
[TD]Carrier D
[/TD]
[TD]Carrier E
[/TD]
[/TR]
[TR]
[TD]True
[/TD]
[TD]False
[/TD]
[TD]False
[/TD]
[TD]True
[/TD]
[TD]True
[/TD]
[/TR]
[TR]
[TD]Data
[/TD]
[TD]Data
[/TD]
[TD]Data
[/TD]
[TD]Data
[/TD]
[TD]Data
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Joe4]

How are these headers being populated?
Are they being populated with Boolean values of True/False, or text values of True/False?

One way to check is to find a False value. Let's say it is cell F5. Then enter these two formulas anywhere on the sheet, and see what they return:
=F5=FALSE
=F5="False"

 

[kcgojnur]

How are these headers being populated?
Are they being populated with Boolean values of True/False, or text values of True/False?

One way to check is to find a False value. Let's say it is cell F5. Then enter these two formulas anywhere on the sheet, and see what they return:
=F5=FALSE
=F5="False"

Cells F5:P5 are being pulled using a formula. When finding a cell w/false and entering the formulas above I get =H5=FALSE, True. =H5="False", False.

I think I see what your saying. It's not recognizing that cell as False. Any suggestions?

 

[kcgojnur]

I figured it out. Instead of choosing false I indicated highlight cells that is not true. =NOT (F$5)

Thanks guys for your help.

 

[Joe4]

Glad you figured it out. You can also use:

[COLOR=#333333]=F$5=FALSE[/COLOR]

(without the quotes - quotes denote literal text, and boolean values are not literal text).
So, FALSE does NOT equal "FALSE"