Previous Topic Next Topic

Conditional Formatting analyzing the a range of cells

Closed
finkasf Posts 1 Registration date Monday November 11, 2013 Status Member Last seen November 11, 2013 - Nov 11, 2013 at 11:49 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 12, 2013 at 11:38 AM
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 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Nov 12, 2013 at 11:38 AM
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.
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Conditional formating - apply on more cells
Biljana -
Raj -

32 responses
one cell will turn green when the two other cells match
diestra123 -
diestra123 -

13 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses