Feb 16 2022 01:21 AM
hi everyone
how I can use conditional formatting in excel with text values to highlight row that contain specific text?
for example
I try apply conditional formatting to my table that contain text "SELL" or "BUY"
but the conditional formatting color only apply for cell itself not row.
I want file row with green color if text = BUY or red color if text = SELL
please find attachment example for my work.
any idea please
Feb 16 2022 01:27 AM
Solution=$D6="SELL"
=$D6="BUY"
Maybe with these rules for conditional formatting and adjusted ranges for conditional formatting (=$B$6:$F$13).
Feb 16 2022 03:49 AM
I certainly learned something valuable from you today, thank you very much for your help.
Feb 16 2022 01:27 AM
Solution=$D6="SELL"
=$D6="BUY"
Maybe with these rules for conditional formatting and adjusted ranges for conditional formatting (=$B$6:$F$13).