Forum Discussion
more conditional formatting help
How do I copy conditional formatting in the instance where I need the numbers in each individual row in the far right column to highlight if the number is greater than (or less than) the number in th...
Thank you Sergei, What steps would I take to copy that formatting down the rest of the rows? I did not have any locks($) on the cells
Simplest way in "Apply To" to change, for example $A$5:$H$5 on $A$5:$H$100 (other word one row on entire your range).
Alternatively Format painter works with Conditional formatting as with any other formatting.