Conditional Formatting - formula for adjacent cells

%3CLINGO-SUB%20id%3D%22lingo-sub-131380%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20-%20formula%20for%20adjacent%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131380%22%20slang%3D%22en-US%22%3E%3CP%3EHi!%2C%20I%20am%20trying%20to%20drag%20a%20conditional%20formatting%20but%20I%20haven't%20been%20able%20to%20do%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20actually%20need%20to%20hide%20the%20value%20in%20the%20column%20T%20if%20the%20value%20in%20Tx%20is%20the%20same%20to%20the%20previous%20value%20in%20the%20same%20column%2C%20ie%2C%20I%20want%20to%20format%20the%26nbsp%3Bfont%20in%20white%20with%20white%20fill%20if%20the%20value%20in%20Tx%20is%20the%20same%20to%20the%20value%20in%20T(x-1)%20and%20used%20from%20T4%20to%20T700.%3C%2FP%3E%0A%3CP%3EHowever%2C%20When%20I%20write%20the%20equation%20and%20I%20define%20the%20range%2C%20the%20same%20equation%20is%20applied%20for%20the%20hole%20range%20and%20it%20doesn't%20change%20when%20I%20move%20down.%3C%2FP%3E%0A%3CP%3EPer%20example%20if%20I%20define%20the%20format%20if%20T5%3DT4%2C%20then%20I%20drag%20it%20down%20and%20In%20the%20cell%20T100%2C%20it%20still%20answer%20to%20the%20condition%20T5%3DT4%2C%20I%20want%20the%20value%20in%20T100%20to%20answer%20to%20the%20condition%20T100%3DT99.%3C%2FP%3E%0A%3CP%3ECan%20anyone%20help%20me%3F%3C%2FP%3E%0A%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131872%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20Formatting%20-%20formula%20for%20adjacent%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131872%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EBetter%20if%20you%20ask%20your%20question%20Excel%20community%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%3C%2FA%3E.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20for%20the%20question%20please%20be%20sure%20your%20rule%20is%3C%2FP%3E%0A%3CPRE%3E%3DT5%3DT4%0Anot%0A%3D%24T%245%3D%24T%244%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi!, I am trying to drag a conditional formatting but I haven't been able to do it.

 

I actually need to hide the value in the column T if the value in Tx is the same to the previous value in the same column, ie, I want to format the font in white with white fill if the value in Tx is the same to the value in T(x-1) and used from T4 to T700.

However, When I write the equation and I define the range, the same equation is applied for the hole range and it doesn't change when I move down.

Per example if I define the format if T5=T4, then I drag it down and In the cell T100, it still answer to the condition T5=T4, I want the value in T100 to answer to the condition T100=T99.

Can anyone help me?

Thanks!

1 Reply

Hi,

 

Better if you ask your question Excel community here https://techcommunity.microsoft.com/t5/Excel/bd-p/ExcelGeneral.

 

As for the question please be sure your rule is

=T5=T4
not
=$T$5=$T$4