Conditional formatting another cell based on text in a range
Solved/Closed
KB2383
Posts
1
Registration date
Wednesday 30 June 2021
Status
Member
Last seen
30 June 2021
-
30 Jun 2021 à 14:58
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 1 Jul 2021 à 12:20
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 1 Jul 2021 à 12:20
Related:
- Insert a new sheet at the end of the tab names and paste the range names starting in cell a1. autofit columns a:b and name the worksheet as range names.
- Where is the insert key - Guide
- Count names in excel - Guide
- Monk names wow - Guide
- Funny ikea names - Home - Apps & Sites
- Excel vba range find - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
1 Jul 2021 à 12:20
1 Jul 2021 à 12:20
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