help on comparing and hiding

  • Thread starter Thread starter justchris
  • Start date Start date
J

justchris

1st off im trying to compare 2 cells and in the third cell i want it t
tell me wether it balances or doesnt balance in words...
example
1st cell100.00
2nd cell102.00 3rd cell<--doesnt balance(in red)

1st cell 100.00
2nd cell 100.00 3rd cell<--balances(in black words)

is there an if statement for this? and if anyone could post it would b
much help.

2nd off =)
i have 2 rows 1st columb is for entering in information 2nd columb i
where the formulas and information from 1st columb gets brought ove
to. What i want to do is hide the first columb from the printer so onl
the second prints out is there a way to do this
 
Try this Formula in Cell 3:
=IF(cell1-cell2=0,"Balance","Does not Balance")

Then select cell 3 and go to Format/Conditional Formating
and enter:

- Condition 1: Cell Value Is- Equal To - "Does not Balance"
then choose in the Format... Field the color red.

Regarding the print thing, in File/page setup, tab Sheet
you can enter the print area.

regards,
Hans
 
=IF((A2=B2),"Balance","Not Balance")
w/ conditional formating cell value - equal to - ="Not Balance" - red
font

Not exactly sure what you mean on the 2nd question but you can manualy
set the print area before printing to exclude any rows or cols you
don't want printed.

Hope this helps

Josh
 
Back
Top