Conditional formatting another cell based on text in a range
Solved/Closed
KB2383
TrowaD
- Posts
- 1
- Registration date
- Wednesday June 30, 2021
- Status
- Member
- Last seen
- June 30, 2021
TrowaD
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Related:
- Conditional formatting another cell based on text in a range
- Conditional Formatting: Highlight cells based on two values ✓ - Forum - Excel
- Conditional formatting: change fontcolor based on another cell ✓ - Forum - Excel
- Conditional formating is applied based on date in two cells ✓ - Forum - Excel
- Conditional formatting in excel based on text in another cell ✓ - Forum - Excel
- Excel conditional formatting color scale based on another cell ✓ - Forum - Excel
1 reply
TrowaD
Jul 1, 2021 at 12:20 PM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
Jul 1, 2021 at 12:20 PM
Hi KB,
Make sure you have a dollar symbol in front of the column letters in your formula and you have set the right range in the 'Applied range' box.
Best regards,
Trowa
Make sure you have a dollar symbol in front of the column letters in your formula and you have set the right range in the 'Applied range' box.
Best regards,
Trowa