If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
if a number lower than 30 than the cell turns yellow??
how can it desribe in excel formule table??
for instance: a1: blank b1: if a130 turn a1 blue, false no change |
#2
|
|||
|
|||
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 a130 turn a1 blue, false no change |
#3
|
|||
|
|||
if a number lower than 30 than the cell turns yellow??
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: =A130 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 a130 turn a1 blue, false no change |
Thread Tools | |
Display Modes | |
|
|