Conditional formatting based on another cell; apply to rows
Solved/Closed
radiofriendlybox
-
Feb 19, 2015 at 06:35 PM
radiofriendlybox Posts 1 Registration date Thursday February 19, 2015 Status Member Last seen February 20, 2015 - Feb 20, 2015 at 11:34 AM
radiofriendlybox Posts 1 Registration date Thursday February 19, 2015 Status Member Last seen February 20, 2015 - Feb 20, 2015 at 11:34 AM
Related:
- Conditional formatting based on another cell; apply to rows
- How to apply @ in laptop - Guide
- Apply the moderate effect smartart style - Guide
- Apply watermark to all pages word - Guide
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Instagram account based in wrong country - Instagram Forum
1 response
cmarzahn
Posts
35
Registration date
Wednesday February 18, 2015
Status
Member
Last seen
March 13, 2015
7
Feb 20, 2015 at 11:22 AM
Feb 20, 2015 at 11:22 AM
I'd play with the conditional format statement to see if changing an absolute cell reference fixes it. When Excel writes them, it looks to set up with a format such as $A$1 which is an "absolute" cell reference to A1. If you make it $A1 instead, as you copy it down a column, it will refer to the cells in column A only but each row will increment as it is copied down.
Feb 20, 2015 at 11:34 AM