Conditional formatting formula help

[Cliffork]

I'm trying to basically hide the text of 6 cells if there is a D at the end of cell B15. I've done this in VBA to hide entire rows before, but how the formatting needed to be for this particular page I can't hide the whole row. I need to just make the text invisible if a serial number ends in a D in B15.

My VBA code for a similar thing with the same reference is:

       If Target.Address(0, 0) = "B15" Then
          With Sheets("Final Insp.")
             If Target.Value Like "*D" Or Target.Value Like "*d" Then
             .Rows("43:48").Hidden = False

I'm just having a hard time wrapping my head around how to write this as a formula. Any ideas?

 

[Joe4]

To do it in Conditional Formatting, just select the 6 cells you want to apply this to, and then use the following Conditional Formatting formula:

=RIGHT(UPPER($B$15),1)="D"

and choose your desired formatting option.

 

[Cliffork]

To do it in Conditional Formatting, just select the 6 cells you want to apply this to, and then use the following Conditional Formatting formula:

=RIGHT(UPPER($B$15),1)="D"

and choose your desired formatting option.

I can see how this would work, I did forget one detail though. the B15 reference point is in another worksheet in the same document called "Info" How do I make it refer to the B15 in that sheet instead of the current one? Nevermind I figured this part out, I just forgot.

Is there also a way to write the formula so if the cell is lacking a D it formats differently so I can rehide the information?

 

[Joe4]

Just add the sheet reference to your range, like you would do for any other formula in Excel, i.e.

=RIGHT(UPPER(Info!$B$15),1)="D"

 

[Cliffork]

Just add the sheet reference to your range, like you would do for any other formula in Excel, i.e.

=RIGHT(UPPER(Info!$B$15),1)="D"

Thank you, and it looks like if the D isn't there it just reverts to whatever formatting it had before the conditional formatting took precedent, so I can just set the opposite to what I need for hiding it before entering the Conditions.

Thank you!

 

[Joe4]

Thank you, and it looks like if the D isn't there it just reverts to whatever formatting it had before the conditional formatting took precedent, so I can just set the opposite to what I need for hiding it before entering the Conditions.

Thank you!

Yes, that is how Conditional Formatting works. If the condition is met, it applies whatever formatting you tell it to.
If it is not met, nothing in the cell changes.

 

[Peter_SSs]

FWIW, if you are using Conditional Formatting there is no need for the UPPER() function. This would do exactly the same thing

=RIGHT(Info!$B$15,1)="D"