Hi,
I have some questions to fully understand what you want.

You write about "format a cell" (= red, bold, etc) but you never write when and what you would like to format (and how you like to format it).

Some more questions:

1a) You write:
A1 greater than or equal to 1
Then
A3 = A2*# from A1

1b) I interpret:
If the value in cell A1 is greater than or equal to 1 (example: 1, 2, 3, 4 etc)
Then
A3 = A2*A1 ("# from A1" I interpret as you mean the content in cell A1).


2a) You write:
If A1 (qty) is greater or less than 1
Then A3 (total) needs to = A1 (qty) x A2 (cost)

2b) I interpret:
If the value in cell A1 (qty) is greater or less than 1 (example: -5, -4, -3, 0, 2, 3, 4, but NOT "1")
Then A3 = A1 * A2 (same as above!!!?!)

Please clarify and I try to help you! Some examples might also help!

Kind regards
Bjorn