is there a way to put colors in a formula...for example, if a4=0, the
background in a4 becomes yellow. ???
is there a way to put colors in a formula...for example, if a4=0, the
background in a4 becomes yellow. ???
You can use Conditional Formatting. In your case:
1. Select A4.
2. Go to Format > Conditional Formatting
3. Choose "Cell Value Is", then choose "Equal to" and put
0 in the third box.
4. Click the Format radio button and format pattern as
yellow.
To see more examples, go to:
http://www.contextures.com/xlCondFormat01.html
HTH
Jason
Atlanta, GA
>-----Original Message-----
>is there a way to put colors in a formula...for example,
if a4=0, the
>background in a4 becomes yellow. ???
>.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks