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
3 Replies
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.
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.
