Microsoft Tech Community is in Read Only mode.  Please enjoy browsing our content while we complete our platform upgrade.

Forum Discussion

tonyg77's avatar
tonyg77
Copper Contributor
Jun 02, 2023

Conditional Formatting on Column E based on corresponding row value in Column B

I've done conditional formatting on a column, base on the value in each row cell of that column and it works fine. Here is one example:

This formats Column B correctly:

 

I want to format Column E, based on the same value in Column B. This is what I have tried to no avail.

1) This is the Rule:

I typed this one as $B$B='Cash Receipt' and below is what it saved it as.

 

2) This is the Rule

I typed this as SEARCH('Cash Receipt', $B$B)>0 and below is what it saved it as:

 

There has to be a correct way to do this. I've read so many posts, replies, articles, etc., but have not found one that works for this.

 

Thanks in Advance

  • tonyg77 

    When you create the rule, E1 should be the active cell in the selection.

    Use the following formula:

     

    =$B1="Cash Receipt"

     

    Note that:

    • The formula that you enter begins with =
    • There is no $ before the row number 1.

    • tonyg77's avatar
      tonyg77
      Copper Contributor

      Yea, I tried that before just to see if I could get it to work for one row. Doesn't work. Besides, I want it to work for all rows in column B & E. 

      I specified $B$B and $E$E, because that is how I did it for others what work as well as the example I showed at the beginning of my post.

       

      This is the rule for the one that works.

       

       

       

       

      HansVogelaar 

Resources