| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula to change cell colour
I would like to colour a cell of the one I am looking at i.e. change cell CF6
to black if BF6="GAL". |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula to change cell colour
You can try conditional formatting
1. Select the cell CF6 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =BF6="GAL" 4. Click Format ButtonPattern and select your color (say Red) 5. Hit OK If this post helps click Yes --------------- Jacob Skaria "Chris Moore" wrote: I would like to colour a cell of the one I am looking at i.e. change cell CF6 to black if BF6="GAL". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell colour change. | Excel Worksheet Functions | |||
| formula to change font or cell colour | Excel Worksheet Functions | |||
| Change colour of cell if there is no value | Excel Worksheet Functions | |||
| Change colour of cell if there is no value | Excel Worksheet Functions | |||
| change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Linear Mode
