| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cells changes colour if....
Hi all
I wonder if you can help with this one I would like cell G6 to change to green if cells B6, E6 and F6 have a Y in them, is this possible? im using office 2007 Many thanks Derek |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Cells changes colour if....
Format/ Conditional Formatting/ Formula Is/ =AND(B6="Y",E6="Y",F6="Y")
Choose your green colour in the format. -- David Biddulph "Derek" wrote in message ... Hi all I wonder if you can help with this one I would like cell G6 to change to green if cells B6, E6 and F6 have a Y in them, is this possible? im using office 2007 Many thanks Derek |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting cells according to their colour | Excel Discussion (Misc queries) | |||
| Formate colour of cells | Excel Discussion (Misc queries) | |||
| Will excel add cells using colour coding eg Add all red cells | Excel Discussion (Misc queries) | |||
| Sum cells by fill colour | Excel Discussion (Misc queries) | |||
| Adding colour to a range of cells based on one of the cells v... | Excel Discussion (Misc queries) | |||
Linear Mode
