if a number lower than 30 than the cell turns yellow??

Q

qtunap

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

Mike H

Hi,

Select A1 then

Format|Conditional format

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

Mike
 
G

Gord Dibben

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 Format>Conditional Formatting>Cell Value is: <30

To turn B1 blue based on A1 value select B1 and Format>CF>Formula is:

=A1<30


Gord Dibben MS Excel MVP
 
Top