(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. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  52. Help needed with Median If in Excel
  53. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  54. How to find a value in an excel column by vba code Cells.Find
  55. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  56. Inline conditions in Lua (a == b ? “yes” : “no”)?
  57. Format JavaScript date as yyyy-mm-dd
  58. Double decimal formatting in Java
  59. ‘Microsoft.ACE.OLEDB.16.0’ provider is not registered on the local machine.
  60. Nested if else in Twig
  61. Scraping data from website using vba
  62. Paste Special error 1004 PasteSpecial method of Range class failed
  63. Why is wp_kses not keeping style attributes as expected?
  64. Nice way to print_r arrays
  65. Completely strip any hidden formatting when pasting into TinyMCE
  66. Place page title in header?
  67. How to prevent automatic conversion of dashes to –
  68. Shortcode from a widget is wrapped in unwanted element
  69. Email sent from WordPress has HTML tags
  70. Pasting code into pre-formatted text in Visual Editor not working in 3.3.1
  71. How to get year, month and hour in WordPress?
  72. Why is WordPress WYSIWYMG and how do I make it WYSIWYG?
  73. Use a language specific thousand separator
  74. Why is this gutenberg custom format button only available from the toolbar as a dropdown?
  75. Selectively remove empty line after line change
  76. Unautop / Sanitize content added to a post through a plugin
  77. Displaying Archives List
  78. trigger html cleanup for all posts
  79. Posting blog entries in screenplay format
  80. Can’t format content of Rich Text Editor in Template
  81. return unformatted content in encosing shortcode
  82. How to amend time format of comments, using child-theme?
  83. What does the Global Variable $s represent?
  84. Images that copy code to clipboard when you click on them
  85. Function sanitize_title() does not appear to be working
  86. WP Editor: Keep Bold, Underline, etc. but ignore color
  87. How to remove filter apostrophe and single quotation
  88. Display KML (or other “raw data” file) nicely in WP?
  89. why doesnt my formatting work in my wisiwig editor?
  90. Style wordpress image captions in RSS
  91. get_the_term_list( get_the_ID() label formatting?
  92. Changing Date Format on Custom Meta Data w/shortcode call
  93. Object of class WP_Error could not be converted to string in /formatting.php
  94. Let custom text widget use the same font as the theme
  95. Theme does not respect spaces between paragraphs in pages
  96. How to prevent wordpress from autoformatting my posts once and for all?
  97. Add Default WordPress Formatting To Data From External SQL Tables?
  98. How to display html code normally?
  99. Fix issue with displaced braces( )
  100. How to show only text from post in WordPress

Leave a Comment

tech