excelexcel-formulaexcel-2013
Excel Highlight one row based on another
I am trying to compare one row with another: IF the cells in Row 1 is equal to Row 2, THEN I must have highlighting. I've tried 100 methods for over an hour now. The problem is that Excel keeps the formula the same across the row!! the formula needs to change, meaning: I am NOT trying to highlight the whole row based on just the first cell, the cell needs to dynamically change. First cell to first cell, 2nd to 2nd, etc. 
The circled words need to be highlighted.
Sorry to ensure everyone is clear on the requirement, here is my requirement:
The solution, as a brilliant guy below mentioned, was a stupid $ sign.
Solution
change the Formula to = A10 = A9 (or just remove the $'s in yours) and Applies To =$A$10:$E$10
- Count the value of the current stock in excel
- Extract time from a date time string in excel
- Easy way to export multiple data.frame to multiple Excel worksheets
- VBA to manually position an Excel pivot when AutoSort is blocked
- Is it possible for HYPERLINK to spill friendly names?
- Loop inside loop. Stop second loop if condition is met
- Using TEXTJOIN to display table values of numbers within certain criteria
- How to Save DataFrame to Excel file using filedialog as SaveAs-Dialog in Python?
- Excel MS365: 2-D dynamic array creation problem
- Search the latest saved PDF file in a various folders and copy the latest one to a specific location
- How do I get all the different unique combinations of 3 columns using VBA in Excel?
- Worksheet names in VBE
- Excel macro to identify 0 crossing of the value
- Format Multienumeration Data for Pivot Table
- VBA Characters.Delete string over 255 characters
- Using Excel, return 1 for all values >0 WITHOUT using an IF
- How can I convert text in a cell to a sequence of ascii code values with a separator in Excel 2016 or LibreOffice?
- How do you copy and paste entire row of source sheet to destination when a date appears in specific column?
- Excel Chart title will not accept a date concatonated to a string
- Calculate average of both the columns and rows using VBA
- filter out multiple criteria using excel vba
- Convert Excel Column Number to Column Name in Matlab
- Consolidate and sum values based on multiple conditions VBA
- Excel number format to only show decimals when necessary
- How to Merge Rows values into a Column on a prior Row?
- Sumif times (datetime format) are greater than 22:30
- Private Sub for hiding worksheets based on cell value "View" / "Hidden"
- Power Query Filtered Rows based on value
- EDI translator to excel
- If formula (the sum is less than 30 then roundup tp 30)