VBA Conditional Formatting Excel 03

Solved/Closed
Report
-
Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
-
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

Posts
2829
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
November 22, 2021
490
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