How do you delete values in a cell based on the cell color (black)

[mathewwheeler]

Right now, I have the rows conditionally formatted (to become black) based on the value in column B. If there are values in row 7, but B7 changes cells D7:K7 to be formatted black, how can I automatically delete the values in cells D7:K7 based on the conditional format?

 

[Fluff]

@mathewwheeler
For future reference
Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. (rule 12 here: Forum Rules).

 

[mathewwheeler]

Question - Is there a way to clear content greater than the value in column C? Column B is the start date, but if I have an end date in column C, is there a way to clear content based on the conditional formatting (if reference value is less than column B or greater than column C, cell color is black)?

Marcelo, I will remove the other post. Apologies for the duplicate.

 

[Fluff]

Not sure I understand.
The code as it stands will clear any cell in the range C:BJ if it is black

 

[Marcelo Branco]

Question - Is there a way to clear content greater than the value in column C? Column B is the start date, but if I have an end date in column C, is there a way to clear content based on the conditional formatting (if reference value is less than column B or greater than column C, cell color is black)?

Marcelo, I will remove the other post. Apologies for the duplicate.

The code i suggested in your original post compares the value entered in column B with Ref Values in row 5 as you asked for. Conditional Format (black) is not relevant since the code converts the text in column B (YR1 M5 for example) in a number. Have you tried it?

M.

 

[Marcelo Branco]

The code i suggested in your original post compares the value entered in column B with Ref Values in row 5 as you asked for. Conditional Format (black) is not relevant since the code converts the text in column B (YR1 M5 for example) to a number. Have you tried it?

M.

See
https://www.mrexcel.com/forum/excel...ng-cell-same-row-post5271806.html#post5271806

M.

 

[mathewwheeler]

@Fluff - you are right... sorry! I just made a slight adjustment and changed the Intersect(Target, Range("B:C") to trigger anytime either column is changed.

Thanks again, and my apologies for the duplicate thread... I'm new and did not think to review the forum rules.

 

[Fluff]

Glad it's sorted & thanks for the feedback