SOLVED

Conditional Formatting for entire row based on data in one cell

Copper Contributor

I am attempting to highlight the whole row yellow if "High" is listed in column B. My conditional formatting formula is shown below and I'm not sure why it's not working. Column B is data validation, allow: list and the source is a selection from the sheet titled Priority.

 

coreygill_1-1708018916866.png

 

 

2 Replies
best response confirmed by mathetes (Silver Contributor)
Solution

@coreygill 

=$B1="High"

This rule for conditional formatting works in my sheet.

=$1:$500

This is the range the format applies to.

conditional formatting.png

1 best response

Accepted Solutions
best response confirmed by mathetes (Silver Contributor)
Solution

@coreygill 

=$B1="High"

This rule for conditional formatting works in my sheet.

=$1:$500

This is the range the format applies to.

conditional formatting.png

View solution in original post