I am trying to highlight any cell in column B that is less than the value in the cell in column A.
If B2 is less than A2 highlight, if B3 is less than A3 highlight etc
Thanks!
I am trying to highlight any cell in column B that is less than the value in the cell in column A.
If B2 is less than A2 highlight, if B3 is less than A3 highlight etc
Thanks!
Select B2:Bxxx,
Conditional Format> New Rule> Format only cells that contain Less than =A2
Select formatting
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
That works great, thanks. Now I want each cell in that column to have the same Conditional Format. When I copy, paste special format it keeps looking back to the original row. I tried to use manage rule to delete the $ sign before the row # with no luck. Any ideas?
I have 2007 but it may work for 2010
highlight column B conditional format / new rule/ =B1<A1 -- format colour
If you select the entire range initially when you apply the rule, Excel will automatically itterate the cells to be consistant. If you didn't do that, go back and clear your rules and start again. Yes, you definitely do not want the anchor $ signs.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks