Conditional Format
I'm trying to apply conditional formatting on the entire row if condition is
met. The Column the conditon is in M. How would I accomplish to turn each row red if anything in Column M has the words "red-jeopardy"? |
Conditional Format
Highlight all the desired rows (I'll assume 2:100).
Under conditional format, change "cell value" to "formula" and paste this formula in: =$M2="red-jeopardy" Apply the desired formatting and save -- Please remember to indicate when the post is answered so others can benefit from it later. "Confused" wrote: I'm trying to apply conditional formatting on the entire row if condition is met. The Column the conditon is in M. How would I accomplish to turn each row red if anything in Column M has the words "red-jeopardy"? |
Conditional Format
Select desired range (assume you start in row 2)
Condition format, formula is: =$M2="red-jeopardy" Format with red pattern. 'ok'. The trick is using the absolute reference on column M. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Confused" wrote: I'm trying to apply conditional formatting on the entire row if condition is met. The Column the conditon is in M. How would I accomplish to turn each row red if anything in Column M has the words "red-jeopardy"? |
All times are GMT +1. The time now is 02:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com