VBA solution for color fill needed

[Newbienew]

Hello,

I have 12 sheets with the same conditional formatting, when I copy and paste the values from another workbook to mine, I run into an error of merged cells same size message. I thought it is easier to use a VBA for the CF, that way if I or anyone else copy and paste the regular way it will not split the CF every time. Would this be possible to turn the CF's into VBA codes and solve my issue? Link> Project App Log

 

[Newbienew]

Any help on my current issue will be greatly appreciated. Link>> Updated Version

 

[Joe4]

I cannot download your files from my current location (workplace security policy blocks those sites), but on the topic of merged cells, is there any way you can get rid of them?
Merged cells are probably the first feature in Excel, and cause NOTHING but issues, especially for things like VBA and sorting.
As such, most serious programmers will not touch them with 10 foot pole!

If you are using merged cells to center values among multiple columns in single rows, you can use the Center Across Selection formatting option instead of using Merged Cells to get the same visual effect, without all the issues caused by Merged Cells.
See: Tom’s Tutorials For Excel: Using Center Across Selection Instead of Merging Cells – Tom Urtis

 

[Newbienew]

This is what it looks like if I did the XL2BB correctly

The CF =IF(OR($V4="REF",$V5="REF"),"TRUE","FALSE CF color is dark orange or brownish
=IF(OR($V4="PMR",$V5="PMR",$V4="TMR",$V5="TMR",$V4="DECL",$V5="DECL"),"TRUE","FALSE") CF color is red
=IF(OR($V4="C/O",$V5="C/O"),"TRUE","FALSE") CF Color is orange
=IF(OR($V4="ENL",$V5="ENL",$V4="AFF",$V5="AFF"),"TRUE","FALSE") Cf Color is green


RANGE is $A$5:$W$56

SEATTLE	2-Nov-21	VORHEES, JASON	(123) 456-7890	PH	NJGFGF	P. ISL	D,4		RE-1	NO	YES	X		YES			PEN	12/22/2021 HOIFEHFEFEF	YES		AFF	YES
CHIS	22-Dec-21				22-Dec-21	F

 

[6StringJazzer]

I'll take a look at what it would for this code, but two things:

First merged cells are almost always a bad approach, as mentioned by Joe4.

Second, it is not necessary to explicitly return TRUE and FALSE with an IF statement for CF rules. If the expression evaluates to TRUE then the rule will apply, otherwise not. Also, you are returning the strings "TRUE" and "FALSE", not the boolean values TRUE and FALSE.

This

=IF(OR($V4="PMR",$V5="PMR",$V4="TMR",$V5="TMR",$V4="DECL",$V5="DECL"),"TRUE","FALSE")

can simply be this

=OR($V4="PMR",$V5="PMR",$V4="TMR",$V5="TMR",$V4="DECL",$V5="DECL")

 

[Newbienew]

Thank you for the info. The format of the cells is above my pay level. For two entries they would have on merged cell, so you would have to type in yes for the first person then space bar and say yes for the second person. This is after using word wrap. There was also the issue with the phone number as well. having 2 cells and the upper one had the number in it but not the lower one.

I didn't realize i could that with the CF. I will be updating it now.