how can it desribe in excel formule table??
for instance:
a1: blank
b1: if a1<30 turn a1 blue, false no change

Hi,

Select A1 then

Format|Conditional format

Cell Value is
Select Less Than
Enter 30 on the right
Pick a colour
Click OK

Mike

"qtunap" wrote:

how can it desribe in excel formule table??
for instance:
a1: blank
b1: if a1<30 turn a1 blue, false no change

If A1 is blank it will always be <30

Which cell do you want to be blue?

A1 or B1?

To turn A1 blue select A1 and FormatConditional FormattingCell Value is: <30

To turn B1 blue based on A1 value select B1 and FormatCFFormula is:

=A1<30


Gord Dibben MS Excel MVP

On Tue, 15 Jul 2008 01:33:02 -0700, qtunap
wrote:

how can it desribe in excel formule table??
for instance:
a1: blank
b1: if a1<30 turn a1 blue, false no change