| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format
How do I do a conditional format saying that if A6 has nothing in it then
turn J6 a certain colour. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format
Hi,
position in cell J6, conditional formating, where the formula is enter a6="" and choose your color "Kevin" wrote: How do I do a conditional format saying that if A6 has nothing in it then turn J6 a certain colour. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format
Try this...
Select cell J6 Goto the menu FormatConditional Formatting Select the Formula Is option Enter this formula in the box on the right: =A6="" Click the Format button Select the desired style(s) OK out -- Biff Microsoft Excel MVP "Kevin" wrote in message ... How do I do a conditional format saying that if A6 has nothing in it then turn J6 a certain colour. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| New Conditional Format Overriding Previous Conditional Format | Excel Discussion (Misc queries) | |||
| How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
| Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
