Conditional formatting across multiple columns
Solved/Closed
wolfy1s13
Posts
3
Registration date
Sunday May 27, 2018
Status
Member
Last seen
May 28, 2018
-
May 27, 2018 at 05:32 AM
wolfy1s13 Posts 3 Registration date Sunday May 27, 2018 Status Member Last seen May 28, 2018 - May 28, 2018 at 02:36 PM
wolfy1s13 Posts 3 Registration date Sunday May 27, 2018 Status Member Last seen May 28, 2018 - May 28, 2018 at 02:36 PM
Related:
- Conditional formatting multiple rows independently
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Conditional formatting if cell contains text - Excel Forum
- If cell contains text then return value multiple conditions ✓ - Excel Forum
- Allow multiple downloads chrome - Guide
- How to delete multiple files at once - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
May 28, 2018 at 11:05 AM
May 28, 2018 at 11:05 AM
Hi Terry,
Using conditional formatting can be quit tricky.
Since you don't want the columns to change you will have to use the absolute symbol ($) in front of them:
=AND($BX3 = $BY3,$BX3<>"")
If you didn't select the range BX3:BY30 before hand, then change applied range to:
=$BX$3:$BY$30
Best regards,
Trowa
Using conditional formatting can be quit tricky.
Since you don't want the columns to change you will have to use the absolute symbol ($) in front of them:
=AND($BX3 = $BY3,$BX3<>"")
If you didn't select the range BX3:BY30 before hand, then change applied range to:
=$BX$3:$BY$30
Best regards,
Trowa
