Conditional Formatting Question

I would like B2 to shade red if laft blank if O2 has any value. Once any value other than blank is assigned to B2 I would like shading to be gone. If O2 is blank B2 would not be shaded.

Make sense? Can it be done?

John PITA

Hi,

Yes it is feasible ...
Conditional Formatting
Formula Is
=O2<>""
format ...

HTH
Carim

perhap I didn't define well.

Data

B1 column is "quanity"
c1 column is "unit price each"
d1 column is "extended price" (=b1*c1)

problem no value is entered in b1 sum of d column is not accurate.
I want b1 to shade red if a whole number is entered in c1

John

Hi,

In cell B2,
Conditional Formatting
Formula Is
=Int(c2)-c2=0

format patterns red

HTH
Carim