Explanation of formula used on conditional formatting
Solved/Closed
Related:
- Explanation of formula used on conditional formatting
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Conditional formatting if another cell contains any text ✓ - Excel Forum
- 1st, 2nd, 3rd position formula in excel ✓ - Office Software Forum
- Conditional format based on another cell containing text - Excel Forum
- Excel conditional formatting if cell contains multiple specific text ✓ - Excel Forum
2 replies
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
544
Nov 12, 2018 at 12:13 PM
Nov 12, 2018 at 12:13 PM
Hi Harry,
That is because of absolute and relative cell references based on dollar symbols in front of either the column letter or the row number or both.
You didn't use the dollar symbol in your cell reference A1, thus making it a relative cell reference. After using the formula for cell A1, Excel will check A2, but also changing the A1 to A2 in the formula.
Try changing A1 to $A$1 in the formula to get the result you were expecting (can also be done with F4 after selecting A1 in the formula).
Does that make sense?
Best regards,
Trowa
That is because of absolute and relative cell references based on dollar symbols in front of either the column letter or the row number or both.
You didn't use the dollar symbol in your cell reference A1, thus making it a relative cell reference. After using the formula for cell A1, Excel will check A2, but also changing the A1 to A2 in the formula.
Try changing A1 to $A$1 in the formula to get the result you were expecting (can also be done with F4 after selecting A1 in the formula).
Does that make sense?
Best regards,
Trowa