VBA Conditional Formatting Excel 03
Solved/Closed
Keldt
-
Jul 22, 2011 at 06:33 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 22, 2011 at 09:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Jul 22, 2011 at 09:05 AM
Related:
- Excel vba conditional formatting formula multiple conditions
- Excel date format dd.mm.yyyy - Guide
- Number to words in excel without vba - Guide
- Excel formula to change cell color without conditional formatting - Excel Forum
- Position formula in excel - Excel Forum
- How to enable vba in excel - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Jul 22, 2011 at 09:05 AM
Jul 22, 2011 at 09:05 AM
Hi Keldt,
Select cell A1, apply conditional fromat using formula: =C1="Done".
Drag cell A1 down to A5 and then to the right to aplly it to range B1:B5.
Best regards,
Trowa
Select cell A1, apply conditional fromat using formula: =C1="Done".
Drag cell A1 down to A5 and then to the right to aplly it to range B1:B5.
Best regards,
Trowa