I need help with conditioning formatting also a count

I need help with conditioning formatting When you reach to 25 it make font bigger change font to dark red & also strikeout whole row with data in it. I have highlight in black I need count of col...

MK11.xlsb10 KB

excel

Formulas and Functions

office 365

sf49ers19238597
Apr 30, 2023
I found the answer that works for me.
The formula is
=COUNTIF($C$2:$C$26, 25)

Thanks You
MK11.xlsb10 KB

HansVogelaar

MVP

Apr 28, 2023

sf49ers19238597

Conditional Formatting can set the font color, as well as bold and strikethrough, but it cannot change the font or font size...

Select the range you want to format.

The active cell in the selection should be in row 2.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=$C2>=25

Click Format...

Activate the font tab.

Make sure that the Strikethrough check box is ticked.

Select bold.

Select dark red as font color.
Click OK, then click OK again.

About the count formula: do you perhaps mean formulas such as

=COUNTIF(C2:C26, 10)

=COUNTIF(C2:C26, 15)

=COUNTIF(C2:C26, 25)

If not, please explain.

sf49ers19238597