Forum Discussion
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
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.
- tonyg77Copper 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.