Conditional Formatting Not Working Properly

[tykc17]

I have a rule that if B5="App" then it should have a light green background and black text and it would go from B5:J5. I applied the rule to the cell and when I have "App" in B5 it only changes the B5 cell and doesn't do the entire row selected for the rule to be applied.

Using Microsoft 356 App for Enterprise

 

[dreid1011]

Is the formula specifically =B5="App" ? To get the entire row highlighted, you should select your entire range B5:J# and then apply the CF rule like this:

=$B5="App"

 

[tykc17]

“App” is tied to a cell in another tab so it’s info!$AB$57

 

[dreid1011]

Can you post a screenshot of your current formula in the CF editor then?

 

[tykc17]

This the same formatting and formula I use on other tabs within this workbook so I don't really understand the reason why it isn't working on this tab

 

[dreid1011]

If you want the entire row B:J to highlight when B5 = INFO!AB97, then I am surprised the formula is working on any tab without locking the B5 reference. Have you tried what I suggested above?

=$B5=INFO!$AB$97