Conditional Formatting Issue

kansfan2001

New Member
Joined
Aug 22, 2020
Messages
21
Office Version
  1. 365
Platform
  1. 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).
1598905674417.png


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

1598905911778.png
1598905946942.png
 

Excel Facts

Copy PDF to Excel
Select data in PDF. Paste to Microsoft Word. Copy from Word and paste to Excel.
Use a formula instead & use
=C15=C$11
 
Upvote 0
Thanks for the help its greatly appreciated :)
That works perfect until I don't have a winner populated. The winners come thru as a formula so maybe that is what is hanging it up?


1598908966174.png


1598908800977.png
 
Upvote 0
Ok, how about
=AND(C15=C$11,C$11<>"")
 
Upvote 0
YOU FRIGGIN ROCK!!!!!!! HOLY COW you just opened up a whole new area of excel for me :) ..... I did not know I could use formulas as conditional formatting.... its just a bit different that using it as a cell function formula...… WHOA!!!! SUPER EXCITED!!!!!!!!

Thanks a bunch!!!!!!!
 
Upvote 0
You're welcome & thanks for the feedback.
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,268
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top