Outputting number of times if a number is equal to or greater than

[mnarvaez99]

Hello all,

I apologize that this probably has been discussed before, but I've searched through the forums and I don't think I'm using the correct terms.

I'll try my best to explain what I'm trying to do

Part 1.

If A2-A10 >= 0.0004, then output number of times(X) it is >= 0.0004 in Cell A11

Part 2.

Color numbers Green that are number of times >=0.0004
Also Color numbers red that are < 0.0004

Part 1 is what I'm most worried about.

Thank you

[FDibbins]

Hi, welcome to the forum

For the 1st part, try this...
=countif(A2:A10,>=0.0004)

For the 2nd part..
1. highlight the range you want to apply the conditional formatting to (A2:A10)
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =A2>=0.0004 format fill GREEN

Repeat 3 and 4 with =A2<0.0004 Format fill RED

[mnarvaez99]

Thank you FDibbins, however I now get a "formula contains an error" message

[FDibbins]

oops sorry...
=countif(A2:A10,">="&0.0004)

[mnarvaez99]

Thank you so much!

[FDibbins]

Happy to help and thanks for the feedback