| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HOW TO FORMAT ANOTHER CELL
I'm trying to set up a formula that will change the format (highlight the
cell) of cell A1 if there is any data (text) in cell C1. Can anyone help me? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW TO FORMAT ANOTHER CELL
This will change the fill colour of A1
select A1, do formatconditional formatting, select formula is and use =$C$1<"" click the format button and click the patterns tab, then select the colour of your choice and click OK twice -- Regards, Peo Sjoblom "Kip Price" <Kip wrote in message ... I'm trying to set up a formula that will change the format (highlight the cell) of cell A1 if there is any data (text) in cell C1. Can anyone help me? Thanks! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW TO FORMAT ANOTHER CELL
click on A1 and:
Format Conditional formatting... Formula Is =ISTEXT(A1) -- Gary''s Student - gsnu200749 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
HOW TO FORMAT ANOTHER CELL
I think you meant =ISTEXT(C1) ?
-- David Biddulph "Gary''s Student" wrote in message ... click on A1 and: Format Conditional formatting... Formula Is =ISTEXT(A1) -- Gary''s Student - gsnu200749 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Can cell format come from and change with reference cell format | Excel Discussion (Misc queries) | |||
| Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
Hybrid Mode
