Function/Formatting

S

Scapa

Have a spreadsheet with a range of numbers(for ref the last 30 lotter
draws) in cells A1:g31. What I would like is - if a number is entere
in say cell m2, a formula or conditional format that would highligh
that number in the range. Is it possible?

Thanking everyone in advance. Scap
 
P

Peo Sjoblom

One way, select A1:G31 with A1 as the active cell (if you start selecting
from A1 it will be active)
or select it by typing A1:A31 in the name box above the row headers
Now do format conditional formatting, formula is

=A1=$M$2

click the format button and select patterns and maybe a red colour
click OK twice
 
B

Bob Phillips

Scapa,

Yes it is with conditional formatting

Select A1:G31
Goto menu Format>Conditional Formatting
Change Condition 1 to Formula Is
Add the Formula =A1=$M$2
Click the format button
Select the pattern tab
Choose a colour
OK
OK

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top