cell auto format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If i have something in block B2, i want something in block A2 to change to a
certain font and fill color. I.E. If it were to say 'A' in b2 then i want
it to be black font and a green fill in A2; and if it said 'B' in B2 i want
it to be black font with a red fill in A2.

is anyone able to help me with this or know where i can look?
 
Hi Greg,

why dont you try to use the conditional formatting feature of excel?
First, you select cell A2 then in the menu bar, you just have to go to
Format --> Conditional Formatting.
Second, in the first drop down arrow, choose "Formula Is".
Third, in the textbox type there "=B2="A" (whatever value you want)
Fourth, you click the format button on the lower right and format it the
way you want A2 will appear.
Fifth, you u still want to add another condition, click the add button
and repeat steps 2 to 5
Sixth, click OK button

However, this one will only work if you only have 3 conditions. if you
have more than 3 i think its much better if you're going to use macro for
that.

Hope this one will help you!

^_^
 
Back
Top