## New answers tagged conditional-formatting

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