Conditional Formatting: Highlight other column if error

[Nanogirl21]

I am having trouble with conditional formatting and am hoping someone could help.

Goal:
If FN24, FN25, FN26 ect returns ERROR then I would like columns D & E of that corresponding row to turn red.

EXAMPLE: FN24 = NO ERROR D24 & E24 = NO CHANGE IN CURRENT CELL COLOR --- FN25 = ERROR D25 & E25 = CHANGE CELL COLOR TO RED --- FN26 = NO ERROR D26 & E26 = NO CHANGE IN CURRENT CELL COLOR

The rows that I would be using is 24-1123

I tried using conditional formatting =ISERROR(FN24:FN1123) Applied to cells D24:E1123, but it did not work.

 

[Fluff]

Try

=ISERROR(FN24)

 

[Nanogirl21]

Try

=ISERROR(FN24)

Ahhh! That was so simple and worked.

For future, how would I modify to change only 1 cell (D21) if anything in the range F24:FN1123 was an error?

 

[Fluff]

How about

=SUM(--(ISERROR(FN24:FN1123)))

 

[Nanogirl21]

SUM(--(ISERROR(FN24:FN1123)))

Perfect. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.