VLOOKUP

[Iryna]

I am not sure if I need to use VLOOKUP function for this
task:
1) For the delta cells, determine the first cell in each
column whose value is above .002 and make it bold.
2) For values after the one above .002, determine the
first one that is below .01 and make it bold.

Thanks Iryna

 

[JE McGimpsey]

Use Conditional formatting instead:

Assuming that your data starts in cell C2, select C2:Cx and enter (with
C2 the active cell):


CF1: =SUMPRODUCT(--(C$2:C2>0.002),--(C$2:C2<0.01))=2
Format1: Bold

CF2: =COUNTIF(C$2:C2,">0.002") = 1
Format2: Bold

 

[Iryna]

Thanks for your help.
Maybe I did something wrong but this formula doesn't work.

Iryna.

 

[Guest]

JE Thanks again,
It's working!!!!

how did you come up with this formula?

Iryna