Forum Discussion
Conditional Formatting issue
Try the following:
Select B6:F91.
B6 should be the active cell in the selection.
On the Home tab of the ribbon, select Conditional Formatting > Manage Rules...
Delete all existing rules.
Click New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=OR(B6=$B$2:$F$2)
Click Format...
Activate the Font tab.
Select Bold, and Red as font color.
Click OK until all dialogs have closed.
Enter the following formula in G6, then fill down:
=SUM(COUNTIF(B6:F6, $B$2:$F$2))
SOLVED
Beautifully done !
Your instructions on creating the Conditional Format and counting results were simple and very clear. And they worked perfectly. I am very grateful for your help.
I was unaware of the OR function and the importance of the sequence of the parameters in the comparison test. I also missed the fact that I could use a range in the criteria portion of the COUNTIF function.
Thank you again.
