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
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Excel if range of cells contains specific text then return value ✓ - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Excel conditional formatting if another cell contains specific text - Excel Forum
- To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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.