Conditional formatting color change if any in row is true

[CLSSY56]

I want to change colors of a group of cells to alert me if any in Row F are true. I tried =$F4:$F64000, but that didn't work.

[Pete_UK]

Note that rows are numbered (1, 2, 3 etc.) and columns have letters to identify them, so "Row F" doesn't make sense. Which group of cells do you want to change colour? What do you mean "if any are true" - does this mean any cells contain the logical value TRUE?

Please give a more detailed explanation, and it will also help if you attached a sample Excel workbook.

Pete

[CLSSY56]

Hello Pete! I'm still working on my vehicle log...

i know above isn't right...

the conditional formatting for A1:E2 needs to turn red if any in Column F = true

[Pete_UK]

Presumably the vehicle log file has moved on since we looked at it a few months ago - can you attach an up-to-date version?

Pete

[CLSSY56]

Let me see if I can reword this...

I need A1:E2 to turn red when any result in Column F is TRUE.

So when I do Conditional Formatting as a formula, what should I have for it to be TRUE if any in Column F is TRUE?

[Fluff13]

Maybe
=COUNTIF($F4:$F64000,TRUE)>0

[CLSSY56]

This is what I did and seems to be working:

F1 formula is =IFERROR(F4:F64000,TRUE)

Then I made A1:E2 Conditionally red and = F1

Does that seem correct?

[CLSSY56]

Nope, I just tested it and it's stuck at true...

[CLSSY56]

Maybe
=COUNTIF($F4:$F64000,TRUE)>0

Yes that worked, thanks.

[Fluff13]

Did you try my suggestion?

[Fluff13]

Oops, should have refreshed the thread before my previous post.

Glad it worked & thanks for the feedback