VBA Conditional Formatting Excel 03

Solved/Closed
Keldt - Jul 22, 2011 at 06:33 AM
TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 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 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
515
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