Format a cell to display multiples of 7

C

Carl

I'm setting up a worksheet to keep score for volleyball matches. The teams
switch sides when the score total for both teams reaches multiples of 7 (ex
7,14,21,28,35,42,49,56) Is there a way to format a cell to display the
multiple in red? I've tried "Conditional Formatting" but it only let me
enter 3 values.
Thanks,
Carl
 
P

Pete_UK

If you want every multiple of 7 to be the same colour, then this is
only one condition. In Format | Conditional Formatting, select Formula
Is rather than Cell Contents, then enter this formula:

MOD(A1,7)=0

assuming the cell you have selected is A1 - change to suit. Click the
Format button, then change the colour to red and OK your way out.

You can then apply the same CF to other cells by using the Format
Painter.

Hope this helps.

Pete
 
R

RagDyeR

Click "Formula Is", and try this:

=AND(C1>0,MOD(C1,7)=0)

With your score in C1.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


I'm setting up a worksheet to keep score for volleyball matches. The teams
switch sides when the score total for both teams reaches multiples of 7 (ex
7,14,21,28,35,42,49,56) Is there a way to format a cell to display the
multiple in red? I've tried "Conditional Formatting" but it only let me
enter 3 values.
Thanks,
Carl
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top