(Excel) Conditional Formatting based on Adjacent Cell Value

You need to take out the $ signs before the row numbers in the formula….and the row number used in the formula should correspond to the first row of data, so if you are applying this to the (“applies to”) range $B$2:$B$5 it must be this formula

=$B2>$C2

by using that “relative” version rather than your “absolute” one Excel (implicitly) adjusts the formula for each row in the range, as if you were copying the formula down

Related Posts:

  1. VBA: Convert Text to Number
  2. MS Excel Scatterplot converts Months to Numbers
  3. Excel to Google Sheets – Error: Formula parse error
  4. Swap x and y axis without manually swapping values
  5. Excel: Calculate the frequency of a particular month in a column of date cells
  6. Object Required Error in excel VBA
  7. Insert picture into Excel cell
  8. What is a correct MIME type for .docx, .pptx, etc.?
  9. Is there Infinity in Spreadsheets?
  10. Declaring variables in Excel Cells
  11. What are .NumberFormat Options In Excel VBA?
  12. Better way to find last used row
  13. VBA, if a string contains a certain letter
  14. How to loop in excel without VBA or macros?
  15. Excel VBA Macro: User Defined Type Not Defined
  16. What is correct content-type for excel files?
  17. How do I get countifs to select all non-blank cells in Excel?
  18. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  19. Excel – SUMIFS for multiple columns
  20. Workaround for “Formula omits adjacent cells”
  21. Select method of Range class failed via VBA
  22. Does VBA contain a comment block syntax?
  23. Why does “Paste Method of Worksheet class failed” occasionally occur?
  24. check if a file is open in Python
  25. How to return a result from a VBA function
  26. Select all the cells below current cell in excel
  27. How to clear memory to prevent “out of memory error” in excel vba?
  28. Use VBA to Clear Immediate Window?
  29. Excel: Can I create a Conditional Formula based on the Color of a Cell?
  30. VBA: Else without If Error
  31. Recommended IDE for VBA
  32. ByRef argument type mismatch in Excel VBA
  33. How do I open space-delimited file in Microsoft Excel?
  34. VBA Error: “Compile error: Expected End Sub”
  35. Using SUBSTITUTE with wildcard characters
  36. Change default ‘delimiters’ in excel
  37. Error: “Could Not Find Installable ISAM”
  38. Adding a newline character within a cell (CSV)
  39. VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)
  40. Loop without Do error
  41. Row count where data exists
  42. Test or check if sheet exists
  43. How to detect if user select cancel InputBox VBA Excel
  44. Shortcut to Apply a Formula to an Entire Column in Excel
  45. macro run-time error ‘9’: subscript out of range
  46. How to label scatterplot points by name?
  47. Why does my VBA code throw an “Invalid outside procedure” error?
  48. Excel Solver Password: what is it and where can it be acquired/bought?
  49. Compile error: Next without For || VBA
  50. Is there a way to crack the password on an Excel VBA Project?
  51. How to prettyprint a JSON file?
  52. Substring in excel
  53. IndexError: too many indices for array
  54. IndexError: too many indices for array
  55. What does <> mean?
  56. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  57. “If not” condition statement in python
  58. Check if something is (not) in a list in Python
  59. IndexError: too many indices for array
  60. Change date format in a Java string
  61. How do I use properly CASE..WHEN in MySQL
  62. Looking for a clear description of Excel’s .xlsx XML format
  63. Help needed with Median If in Excel
  64. Invalid column count in CSV input on line 1 Error
  65. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  66. Invalid column count in CSV input on line 1 Error
  67. Expected RBRACE, but the bracket is there?
  68. How to find a value in an excel column by vba code Cells.Find
  69. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  70. What Excel formula returns the sheet name?
  71. How can I remove punctuation from input text in Java?
  72. excel IF formula Error, “You’ve entered too many arguments”
  73. Python conditional assignment operator
  74. Export html table data to Excel using JavaScript / JQuery is not working properly in chrome browser
  75. std::string formatting like sprintf
  76. Inline conditions in Lua (a == b ? “yes” : “no”)?
  77. How to fix file format and extension don’t match?
  78. Convert java.util.Date to String
  79. Don’t understand this SyntaxError: illegal target for annotation
  80. How can I remove punctuation from input text in Java?
  81. How to print elements from array with javascript
  82. HTML IF Statement
  83. Format JavaScript date as yyyy-mm-dd
  84. How can I open an Excel file in Python?
  85. ValueError: cannot index with vector containing NA / NaN values
  86. How to format numbers as currency strings
  87. What does {0} mean when found in a string in C#?
  88. How can I import an Excel file into SQL Server?
  89. How to run a SQL query on an Excel table?
  90. What is the function of FormulaR1C1?
  91. What exactly is the function of Application.CutCopyMode property in Excel
  92. Double decimal formatting in Java
  93. How to print a number with commas as thousands separators in JavaScript
  94. VBA Excel – Insert row below with same format including borders and frames
  95. ImportError: No module named win32com.client
  96. Is it possible to force Excel recognize UTF-8 CSV files automatically?
  97. when to use if vs elif in python
  98. Properly formatted multiplication table
  99. Excel Filters – show only relevant values in the filter
  100. Easy pretty printing of floats?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)