CF

H

Herman

how do i CF a cell when the info in that cell equals the
info in another cell. ie
b6 has a formula counting a range of cells
b5 has a number entered into it

when b6 = b5 then CF so that I know they match.
thanks in advance
Herman
 
L

Lady Layla

Exactly

: how do i CF a cell when the info in that cell equals the
: info in another cell. ie
: b6 has a formula counting a range of cells
: b5 has a number entered into it
:
: when b6 = b5 then CF so that I know they match.
: thanks in advance
: Herman
 
B

Bob Phillips

Herman,

In B5, within B5, set the condition to equal to, and the value to =B6, Set
the format to suit.

Converse for B6.

--

HTH

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