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 Contributor Last seen December 27, 2022 - Nov 12, 2013 at 11:38 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Nov 12, 2013 at 11:38 AM
Related:
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names.
- My contacts list names - Guide
- Count names in excel - Guide
- Monk names wow - Guide
- How to insert at the rate in laptop - Guide
- Where is the insert key on a laptop - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
Nov 12, 2013 at 11:38 AM
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.
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.
