Brandon
Reputation: 117
How to copy conditional formatting to another cell so that the custom formula cell variables change based on the location of the cell youre pasting to
When I copy and paste special > conditional format, it only updates the range, not the formula. Is there a way to paste the custom conditional format to update the variables of the formula as well? For example. If I paste the formula one cell to the right, it would say =G44>=today().
Upvotes: 0
Views: 109
Answers (1)
idfurw
Reputation: 5862
It is already applied as the way you say
i.e. the condition of G49 in the 2nd screenshot is =G44=>today()
Upvotes: 1
Related Questions
- Copying Cell Value On The Same Row Based On Another Column Cell Color
- Google Sheets Copying Conditional Formatting while adjusting formulas
- Keep the conditional formatting on pasting value
- Paste conditional formatting when conditional formatting formula is absolute
- Excel: How to copy/paste Conditional Formatting, as if the condition were a "value"?
- Copying conditional formatting in google sheets
- how can I copy a conditional formatting in Excel 2010 to other cells, which is based on a other cells content?
- Copy conditional formatting based on cell content to other rows
- Copy conditional formatting to other rows
- Copying conditional Formatting in Excel