Quote:
Originally Posted by gebobs
Select all the values in column B. Go to conditional formatting and New Rule.
Format Only Cells That Contain
Set condition to "equal to".
For the range, type in "=$A2". If you select the cell to enter this, be sure to delete the $ between the A and the 2.
Set your formatting. Press OK. Repeat for the other rules accordingly.
|
There are 6 type of rule in New formatting rule. Which one I should select and will you please explain more clearly about the range you have written ?
"=$A2" & be sure to delete the $ between the A and the 2. I did not get this one.