Forum Discussion
Copying Conditional formatting with relative cell referencces in the formula desn't work
That's a normal behaviour. Dragging Format Painter from T4 to T14 you apply conditional formatting to entire range T4:T14. Excel take formula for the first cell in the range as the basis and apply it internally to each cell in the range. Exactly the same will be if you first select T4:T14 range, add rule formula for the first cell, e.g. T4>A4 and apply to entire range - formula itself isn't changed if you check CF for any other cell within the range.
SergeiBaklan, it may be normal behavior, but it seems that if the feature allowed for relative references in the range field that you would be able to paint a much larger range at a time and preserve the proper reference. Without that, I'm having to paint one row at a time, 500 times.
- It's not reasonable behavior when relative references are used.
Hello Jim,
Maybe you already solved what you were looking for. If not, please visit this website.
With just a few clicks it is possible to set the conditional format for thousands of lines. The first example in this website is "crazy" at first glance but it works smoothly. It solved my problem! and there, the author offers several good examples of conditional formatting.https://exceljet.net/conditional-formatting-with-formulas
- Nope. That site DOES NOT discuss the USE CASE that several of us are asking about here in this thread.
mrkuramotothanks for the link, I'll give it a try later :)
