Does anyone how to use conditional formatting in Excel in order to have more than 3 conditions?
You can use a VBA sub with a very simple “Select Case” construct to define color depending on the value. Add the following macro to your personal workbook (Alt-F11, right click the Personal Workbook in the VBA project window and select “add module” then paste the snippet of code in the main VBA window) When you want to implement the formatting, just select the range that needs to be conditionnaly formatted and execute the macro. As it is, the macro evaluates a cell value and give to its immediate neighbour on the right the associated color. If you want to change the relative positions between evaluated cell and formatted cell, just change the values in all the Offset() of the code. The first argument is the row difference and the second the column difference. There is no limit in the number of conditions you can use, just add more “Case” statements mimicking the syntax used here to increase the granularity of your conditionnal formatting.
