kansfan2001
New Member
- Joined
- Aug 22, 2020
- Messages
- 21
- Office Version
- 365
- Platform
- Windows
Howdy,
I am using a VBA to pull information from Sheet 1 and dumps it on sheet 2. Basically its removing the formulas and makes everything text. I have set conditional formatting to automatically format the cells based on who the winner of the fight is. But I am having a problem with getting the conditional formatting to not format the fighters when the match winner and losers are not defined. Does anyone have a clue as to how I can fix this. That way when I do not have a winner or loser defined the conditional formatting will not do what its doing to match one fighters (all red when no body is defined above).
Sheet 2: All cells below row 14 are text and have no formulas coming over. The winners and loser of the match names are coming from another page that defines who the winner is (formulas).
All I want to do is not have the conditional formatting happen if I have no match winner or loser selected. Right now it just goes Red and strikes the word
I am using a VBA to pull information from Sheet 1 and dumps it on sheet 2. Basically its removing the formulas and makes everything text. I have set conditional formatting to automatically format the cells based on who the winner of the fight is. But I am having a problem with getting the conditional formatting to not format the fighters when the match winner and losers are not defined. Does anyone have a clue as to how I can fix this. That way when I do not have a winner or loser defined the conditional formatting will not do what its doing to match one fighters (all red when no body is defined above).
Sheet 2: All cells below row 14 are text and have no formulas coming over. The winners and loser of the match names are coming from another page that defines who the winner is (formulas).
All I want to do is not have the conditional formatting happen if I have no match winner or loser selected. Right now it just goes Red and strikes the word