| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Contional Formatting - other cells
I need to set a condition for formatting cell F5 based on the value of cell
E6. ow do I do this? Thanks -- A MACKENZIE, CMA, MBA |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Contional Formatting - other cells
Use conditional formatting, change the condition to formula is and a formula
of =$E$6=value -- HTH Bob Phillips (remove nothere from email address if mailing direct) "aMack" wrote in message ... I need to set a condition for formatting cell F5 based on the value of cell E6. ow do I do this? Thanks -- A MACKENZIE, CMA, MBA |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Contional Formatting - other cells
Thanks.
Now if the value needs to be "NULL" or Blank - what is the value? -- A MACKENZIE, CMA, MBA "Bob Phillips" wrote: Use conditional formatting, change the condition to formula is and a formula of =$E$6=value -- HTH Bob Phillips (remove nothere from email address if mailing direct) "aMack" wrote in message ... I need to set a condition for formatting cell F5 based on the value of cell E6. ow do I do this? Thanks -- A MACKENZIE, CMA, MBA |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Contional Formatting - other cells
=$E$6=""
or =LEN($E$6)=0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "aMack" wrote in message ... Thanks. Now if the value needs to be "NULL" or Blank - what is the value? -- A MACKENZIE, CMA, MBA "Bob Phillips" wrote: Use conditional formatting, change the condition to formula is and a formula of =$E$6=value -- HTH Bob Phillips (remove nothere from email address if mailing direct) "aMack" wrote in message ... I need to set a condition for formatting cell F5 based on the value of cell E6. ow do I do this? Thanks -- A MACKENZIE, CMA, MBA |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Contional Formatting - other cells
YESSSSSS!!!!!!
-- A MACKENZIE, CMA, MBA "Bob Phillips" wrote: =$E$6="" or =LEN($E$6)=0 -- HTH Bob Phillips (remove nothere from email address if mailing direct) "aMack" wrote in message ... Thanks. Now if the value needs to be "NULL" or Blank - what is the value? -- A MACKENZIE, CMA, MBA "Bob Phillips" wrote: Use conditional formatting, change the condition to formula is and a formula of =$E$6=value -- HTH Bob Phillips (remove nothere from email address if mailing direct) "aMack" wrote in message ... I need to set a condition for formatting cell F5 based on the value of cell E6. ow do I do this? Thanks -- A MACKENZIE, CMA, MBA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deferring conditional formatting? | Excel Discussion (Misc queries) | |||
| Formatting a group of cells for text | Excel Discussion (Misc queries) | |||
| Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
| Excel should allow more options for formatting cells | Excel Worksheet Functions | |||
| How to copy "edge" formatting to other cells. | Excel Discussion (Misc queries) | |||
Linear Mode
