SOLVED

conditional formatting

%3CLINGO-SUB%20id%3D%22lingo-sub-2004408%22%20slang%3D%22en-US%22%3Econditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2004408%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20trying%20to%20conditionally%20format%20an%20excel%20sheet.%20I%20have%2012%20columns%20and%2011%20rows%3B%20I%20want%20each%20cell%20to%20compare%20to%20the%20previous%20cell%20in%20that%20row.%20If%20the%20value%20is%20higher%2C%20the%20font%20is%20green%3B%20if%20the%20value%20is%20lower%20the%20font%20is%20red%3B%20and%20if%20the%20value%20is%20the%20same%2C%20the%20font%20is%20blue.%20I%20can%20make%20it%20work%20for%20the%20first%20column%20but%20if%20I%20try%20to%20continue%20it%20across%20all%20columns%2C%20it%20always%20compares%20to%20the%20original%20cell%20in%20column%20A.%20How%20can%20I%20set%20it%20up%20to%20always%20compare%20the%20cell%20to%20the%20immediate%20left%20(e.g.%20compare%20cell%20in%20Row%201%2C%20Column%20C%20to%20cell%20in%20Row%201%2C%20Column%20B%3B%20then%20compare%20cell%20in%20Row%201%2C%20Column%20D%20to%20cell%20in%20Row%201%2C%20Column%20C%2C%20etc)%20%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2004408%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2004449%22%20slang%3D%22en-US%22%3ERe%3A%20conditional%20formatting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2004449%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F907344%22%20target%3D%22_blank%22%3E%40Holly710%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20seems%20you%20are%20using%20absolute%20reference%20in%20the%20formula%2C%20you%20will%20find%20the%20%24%20and%20you%20have%20to%20remove%20it.%3CBR%20%2F%3EYou%20can%20remove%20it%20manually%2C%20or%20by%20pressing%20F4%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20If%20my%20post%20helped%20you%2C%20please%20click%20on%20like.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I'm trying to conditionally format an excel sheet. I have 12 columns and 11 rows; I want each cell to compare to the previous cell in that row. If the value is higher, the font is green; if the value is lower the font is red; and if the value is the same, the font is blue. I can make it work for the first column but if I try to continue it across all columns, it always compares to the original cell in column A. How can I set it up to always compare the cell to the immediate left (e.g. compare cell in Row 1, Column C to cell in Row 1, Column B; then compare cell in Row 1, Column D to cell in Row 1, Column C, etc) ?

2 Replies
best response confirmed by Holly710 (New Contributor)
Solution

Hi @Holly710 

 

It seems you are using absolute reference in the formula, you will find the $ and you have to remove it.
You can remove it manually, or by pressing F4

 

 

* If my post helped you, please click on like.

@Jihad Al-Jarady 

perfect! Problem solved - thanks so much!