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

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

Vba conditional formatting multiple conditions
Vba case like - Guide
Number to words in excel without vba - Guide
Allow multiple downloads chrome - Guide
Conditional formatting if two cells match ✓ - Excel Forum
How to delete multiple files at once - Guide

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
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

Excel - IF function with multiple words

How to use conditional format based on text?

Highlight cell if another cell contains specific text

Highlight cell if another cell contains any text

Conditional formating - apply on more cells

Similar discussions

Subscribe To Our Newsletter!