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

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
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
0