Conditional Formating on more than one cell
Closed
AB
-
Feb 8, 2012 at 07:26 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2012 at 10:30 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 9, 2012 at 10:30 AM
Related:
- Conditional Formating on more than one cell
- Based on the values in cells b77:b81, what function can automatically return the value in cell c77? ✓ - Excel Forum
- Conditional formatting if two cells match ✓ - Excel Forum
- Excel formula to change cell color without conditional formatting - Excel Forum
- Excel conditional formatting if another cell contains specific text - Excel Forum
- Apply conditional formatting to the selected cells ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Feb 9, 2012 at 10:30 AM
Feb 9, 2012 at 10:30 AM
Hi AB,
The formula you are using is probably: =$A$3>$A$2
The dollar sign in front of A will stop A from becoming B when dragged to the right.
So remove the dollar signs: =A$3>A$2.
Also don't copy-paste, just drag and when done a small square should appear. Clicking it will give you the option to keep format only, thus keeping the values you might have overwrittin by dragging.
Best regards,
Troaw
The formula you are using is probably: =$A$3>$A$2
The dollar sign in front of A will stop A from becoming B when dragged to the right.
So remove the dollar signs: =A$3>A$2.
Also don't copy-paste, just drag and when done a small square should appear. Clicking it will give you the option to keep format only, thus keeping the values you might have overwrittin by dragging.
Best regards,
Troaw