Select rowS C3:BB3 > click ok Conditional Formatting > click Format only cells that contain > select equal to > type formula =B3="Wave Street"> select format >then ok
Select C3:BB3
Conditional formatting
New rule
Use a formula to determine which...
In the formula field:
=$B3="Wave Street"
(Dollar sign is important)
Press Format button
Select formatting (Fill tab, choose red color)
This works and highlights just one cell. I'm looking at the first thing I posted on this and maybe should of been clearer on it.
IF "Wave Street" in any cell in Column B. Then highlight that row range C5 to AA5. So that means Wave Street would be in Column B5. Thanks and sorry for any confusion
ill be honest I still cant get this to work for some reason. =$B3="Wave Street" using this then I did this =$B3:$B100="Wave Street"
What I'm just trying to do if this name Wave Street exists in Column B then highlight in that same row from C to AA. So if word was in B6. Then would highlight C6:AA6.
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.