Feb 15 2024 09:47 AM
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.
Feb 15 2024 11:20 AM
Solution=$B1="High"
This rule for conditional formatting works in my sheet.
=$1:$500
This is the range the format applies to.
Feb 15 2024 12:59 PM
Feb 15 2024 11:20 AM
Solution=$B1="High"
This rule for conditional formatting works in my sheet.
=$1:$500
This is the range the format applies to.