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 December 27, 2022 - Jul 22, 2011 at 09:05 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jul 22, 2011 at 09:05 AM
Related:
- Excel vba conditional formatting formula multiple conditions
- Number to words in excel formula without vba - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- Position formula in excel ✓ - Excel Forum
- Formulas for 1st and 2nd position in class - Office Software Forum
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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