| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Cond Format - C6 when G6 contains any text
Hi
I have spent a couple of hours reading through previous posts but cannot seem to find quite what I am looking for. I want to CF a range of cells in one column depending on there being any text in the corresponding range of another column. ie Change the background of any cell in (C6:C41) only if "any" text is put into the corresponding cell in (G6:G41) So, if I type any length of text into G19, C19's background will change colour. Hope I have explained this OK. -- Thanks, Rob |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding / Cond. Format | Excel Discussion (Misc queries) | |||
| Whole Row Cond. Format | Excel Discussion (Misc queries) | |||
| Cond. format text color based on another's text color | Excel Discussion (Misc queries) | |||
| cond format | Excel Worksheet Functions | |||
| How do I use cond format formula to set cell text and color? | Excel Discussion (Misc queries) | |||
Threaded Mode
