CF

  • Thread starter Thread starter Herman
  • Start date Start date
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
 
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
 
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)
 
Back
Top