Conditional formatting another cell based on text in a range
Solved/Closed
KB2383
Posts
1
Registration date
Wednesday June 30, 2021
Status
Member
Last seen
June 30, 2021
-
Jun 30, 2021 at 02:58 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 1, 2021 at 12:20 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 1, 2021 at 12:20 PM
Related:
- Conditional formatting another cell based on text in a range
- If a cell has text then return value ✓ - Excel Forum
- Clear only the formatting from the selected cell (leaving the content) - Guide
- Instagram account based in wrong country - Instagram Forum
- 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. ✓ - Excel Forum
- Based on the values in cells b77 ✓ - Excel Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jul 1, 2021 at 12:20 PM
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