Formula for numbers=color

  • Thread starter Thread starter Vile
  • Start date Start date
V

Vile

I am trying to make a cell or the numbers in a cell turn red when they
are certain numbers, like 20 for example. If I enter 20 in the cell
it turns red. Trying to make a lotto sheet so I can easily find my
lotto numbers.

Thanks
 
I am trying to make a cell or the numbers in a cell turn red when they
are certain numbers, like 20 for example. If I enter 20 in the cell
it turns red. Trying to make a lotto sheet so I can easily find my
lotto numbers.

Thanks
Click to expand...

Look at Conditional Formatting (under the Format menu).

If that does not work, you will need to describe what you require more
completely.


--ron
 
I have been playing around with conditional formatting and am getting
nowhere. I want a cell to turn red or the number to turn red when a
certain set of numbers come up, for the lotto for example. I got one
number to come up red so far, that is the cell turns red, but I want
more numbers to come up red and it only lets me do this in a chain
about 3 times. I thought it would be like (2,7,5,8,) but that does
not work so far, is it a if (3,33,4,65,)? That won't work either, I
need 6 numbers to work in a cell that turn red.
 
I have been playing around with conditional formatting and am getting
nowhere. I want a cell to turn red or the number to turn red when a
certain set of numbers come up, for the lotto for example. I got one
number to come up red so far, that is the cell turns red, but I want
more numbers to come up red and it only lets me do this in a chain
about 3 times. I thought it would be like (2,7,5,8,) but that does
not work so far, is it a if (3,33,4,65,)? That won't work either, I
need 6 numbers to work in a cell that turn red.
Click to expand...

Put your winning numbers into a range someplace with each number in a separate
cell. Then select that range and name it (Insert/Name/Define) Winning_Numbers.

Next select the range where you are entering the numbers that come up in the
lotto, or bingo or whatever. Let us assume that range is A1:E10.

After selecting that range: Format/Conditional Format/ Formula Is:

=COUNTIF(Winning_Numbers,A1)=1

(For A1 substitute the active cell in your selected range).

Format to taste -- I like white/bold for the Font and Red for the patterns.

All of the cells should be properly formatted with the A1 adjusted to match the
cell by virtue of how you entered the formatting.

You can now change the winning numbers in the Winning_Numbers range, and the
formatting will change accordingly in your actual numbers range.


--ron
 
Back
Top