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

Hello,

How can i apply a conditional format on a certain cell but with the condition in a different cell.

F.e. if a cell in range C1:D5 (f.e. C1) has value "Done" then cell in range A1:B5 (C1 -> A1) should be green

Thx for the help
Kedlt

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

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 549
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

Similar discussions

How to use conditional format based on text?

Excel - IF function with multiple words

How to calculate positions (1st,2nd,3rd...) in Excel

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Similar discussions

Subscribe To Our Newsletter!