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
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 12, 2013 at 11:38 AM
Related:
- Conditional Formatting analyzing the a range of cells
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Based on the values in cells b77 b81 ✓ - Excel Forum
- 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. ✓ - Excel Forum
- How would you change all cells containing the word pass to green - Excel Forum
- Apple airtag range - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
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.
