Forum Discussion
Excel Coding and Conditional Formatting
I am trying to make a code where if a specific work is in column f it will change any number greater than 0 to red in specific columns within the same row as the word. For example Cell F6 says Ca...
This is the rule for conditional formatting in the screenshot. The keywords can be entered in range A2:A50.
=AND(MATCH($F6,$A$2:$A$50,0),G6>0,ISNUMBER(G6))This is the range the conditional format applies to.
=$G$6:$N$12
Does the screenshot show your expected result?