Cell Conditional Formatting

[agonysWeeper]

Hi Forum,

I have cell A1 and B1
A1 contain the qty
B1 contain the formula and I am looking for conditional formating or any other way because B1 has a shade (fill color) "black color, B1 has a formula of =IF(K28,IF(K28=1,"pc","pcs"),"") then I want a conditional formatting if A1 has a number the fill color black will turn to white.

looking forward for soonest reply
thanks.

 

[CWatts]

I'm having difficulty following, but you can attempt this:

=A1>0

Which basically tests if A1 is greater than 0. If that is true, then it will apply the format, which you can use the white background with.

I hope that's what you're looking for.

 

[agonysWeeper]

Sorry just to clarify

I try to put a conditional format in column B but showing like this, not working.

 

[agonysWeeper]

What I need is when A1 has 1 or more than 1 B1 should show pc or pcs while cell background clean color white, then when A1 has no data or number Cell B1 should look like B3.

 

[CWatts]

Try these steps.

Select cell B1
Home Tab
Conditional Formatting
Manage Rules
New Rule
Use a Formula
=OR(A1="",A1=0)
Choose the formatting you want and click OK and click OK again so you're back at your list of rules.
When you have you list of rules, where it says "Applies to...", change the range to however far your data in column B goes, or just =B:B for the whole column.

Click Ok