Hi All,
I'm trying to use conditional Format to highlight cells in Column C that refer to Column B.
I hope that explains it all. Please assist if possible. Thanks all!
-Andrew
Hi All,
I'm trying to use conditional Format to highlight cells in Column C that refer to Column B.
I hope that explains it all. Please assist if possible. Thanks all!
-Andrew
maybe you can try this:
Go to conditional formatting > New Rule > Use a formula
then type this formula =AND($B1<>"",$C1=$B1)
choose the applicable format then apply to column C ($C:$C)
If I've helped U pls click on d *Add Reputation
Do you mean you want to change the color of cells that have a formula in them that refeneces anpother cell?
If so, then sorry, CF cannot do that. All regular formulas work on what is displayed in a cell, not what the contents are - in other words, if a cell has =1+2, it will show 3, and excel will only see 3
If, on the other hand, you mean you want to change C based on what B shows, then, you will need to give additional info please
On a side note, bhenlee, you should avoid applying CF to entire columns, it will start to slow your file down
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks