Conditional Formatting analyzing the a range of cells

[Closed]
Report
Posts
1
Registration date
Monday November 11, 2013
Status
Member
Last seen
November 11, 2013
-
Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
-
Hello,

I have an excel workbook with multiple tabs that contain many internal checks. Therefore, I created a "summary tab" that uses conditional formatting to confirm the checks on the other tabs (ex: =IF('Indirect'!B25<5,IF('Indirect'!B25>-5,"OK","ERROR")). Unfortunately, the summary tab is lengthy and does not easily fit on a screen.

I would like a single cell (ex: B5) to change color if the result of any of the formulas in the summary tab produce an "ERROR". Is it possible to use conditional formatting in a single cell to analyze the results of formulas in a range of cells?

Thanks for your help!!!

1 reply

Posts
2818
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 18, 2021
486
Hi Finkasf,

Count the number of ERROR's in a column using the COUNTIF function.
Then use the IF function to determine if an ERROR is found.

Combine the 2 like:
=IF(COUNTIF(B1:B4,"ERROR")>0,TRUE,FALSE)

Apply the above formula in conditional formatting picking a color of your choice.

Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.