View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default if a number lower than 30 than the cell turns yellow??

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