New answers tagged

0

An alternative of making spaces in numbers is by using " " I formatted a number 1043622 to look like 10 436 22 by using format 00" "000" "00


0

After reviewing the comment of teylyn, I found the solution, in cell A1 in worksheet2, I also referred to cell A1 of worksheet1; and this solved the problem. Thank you.


0

in cell A1 date of Birth in cell B1 age with the formula with the conditional formatting: =TEXT($B1,"DD/MM")-TEXT(TODAY(),"DD/MM")=0 Having age in B1, are you sure your conditional formula works? Isn't it referring to A1?? As sheet2 contains age, not date of birth, use this formula: =FIND(B1," 0 Months, 0 Days")>0


0

You can add a sheet reference to your conditional formatting formula on sheet 2 to refer to the source cell on sheet 1. =TEXT(Sheet1!$A1,"DD/MM")-TEXT(TODAY(),"DD/MM")=0


1

The solution below was posted on StackOverflow by Scott Craner to the same question (posted there because there was no working answer here): Use this formula: =NOT(AND(A2=OFFSET(A2,COUNTIF($A2:$A$82,A2)-1,0),A2=OFFSET(A2,-(COUNTIF($A$2:$A2,A2)-1),0))) If changing the range then make sure to pay attention to what is marked as absolute and ...


0

Conditional formatting is part of the cell formatting. Paste your cells without formatting and you will not bring over the conditional formatting.


1

In both examples, Applies To I have set to =$A$1:$J$5 Case Insensitive: =LEFT($A1,5)="Volum" Case Sensitive: =EXACT(LEFT($A1,5),"Volum")


1

For these specific functions you can do it easily with a support range where you store parameters for SUBTOTAL: Where the formula in D1 is =SUBTOTAL(VLOOKUP(A1,$B$4:$C$6,2,0),B1:C1) VLOOKUP, based on value in A1 selects the correct parameter for SUBTOTAL


1

I don't think you can use a formula in the Highlight Cells conditional format. You need to use a conditional format that uses a formula. Select D2 to D100 in Expired Data, then go Conditional Formatting > New Rule > Use a formula to determine... Enter this formula: =D2>VLOOKUP(C2,'Pivot Table'!$A$1:$F$100,2,0) Please note the position of the $ sign, ...



Top 50 recent answers are included