| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF statement to make cells change shading
Is there any way that I can put a conditional format in an IF statement when
if it is true certain cells change shading? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF statement to make cells change shading
Absolutely!
You can put the IF in the conditional format using the: Formula Is option -- Gary''s Student - gsnu200724 "RobertM" wrote: Is there any way that I can put a conditional format in an IF statement when if it is true certain cells change shading? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF statement to make cells change shading
I'm interested in the conditonal formatting change the shading of more than
one cell. Any suggestions? "Gary''s Student" wrote: Absolutely! You can put the IF in the conditional format using the: Formula Is option -- Gary''s Student - gsnu200724 "RobertM" wrote: Is there any way that I can put a conditional format in an IF statement when if it is true certain cells change shading? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF statement to make cells change shading
Select the cells to CF and go from there.
e.g. you want A1:A12 to change color when B1 is a certain value like 123456 Select A1:A12 and CFFormula is: =$B$2=123456 Pick a color and OK your way out. Gord Dibben MS Excel MVP On Fri, 25 May 2007 11:02:00 -0700, RobertM wrote: I'm interested in the conditonal formatting change the shading of more than one cell. Any suggestions? "Gary''s Student" wrote: Absolutely! You can put the IF in the conditional format using the: Formula Is option -- Gary''s Student - gsnu200724 "RobertM" wrote: Is there any way that I can put a conditional format in an IF statement when if it is true certain cells change shading? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Applying conditional formating to make cells change color | Excel Discussion (Misc queries) | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| How do I make an IF statement change cell shading | Excel Worksheet Functions | |||
| How do i make a range of cells change colour | Excel Worksheet Functions | |||
| Is there a way to change the default shading color ? | Excel Discussion (Misc queries) | |||
Hybrid Mode
