| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
put zero in blank cell using conditional formatting
Win XP Pro
Office XP I wish to create a third condition format by placing a zero in blank cells please? Terry |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
put zero in blank cell using conditional formatting
Can't do that with conditional formatting. Can only set:
font border pattern -- Gary''s Student gsnu200711 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
put zero in blank cell using conditional formatting
Thanks Gary....I had got "bogged" down with it hence post.
Terry "Gary''s Student" wrote in message ... Can't do that with conditional formatting. Can only set: font border pattern -- Gary''s Student gsnu200711 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
put zero in blank cell using conditional formatting
it is not possible,
you can, select the range, press F5, special, chose empty cells only, type 0 and CTRL + Enter hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Terry" escreveu: Win XP Pro Office XP I wish to create a third condition format by placing a zero in blank cells please? Terry |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
put zero in blank cell using conditional formatting
Thanks Marcelo...I am unable to find "empty cells only" in special, so
unable to complete. Regards Terry...UK "Marcelo" wrote in message ... it is not possible, you can, select the range, press F5, special, chose empty cells only, type 0 and CTRL + Enter hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Terry" escreveu: Win XP Pro Office XP I wish to create a third condition format by placing a zero in blank cells please? Terry |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
put zero in blank cell using conditional formatting
Blank, not "empty"
"Terry" wrote in message ... Thanks Marcelo...I am unable to find "empty cells only" in special, so unable to complete. Regards Terry...UK "Marcelo" wrote in message ... it is not possible, you can, select the range, press F5, special, chose empty cells only, type 0 and CTRL + Enter hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Terry" escreveu: Win XP Pro Office XP I wish to create a third condition format by placing a zero in blank cells please? Terry |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Worksheet Functions | |||
| Conditional formatting - Blank | Excel Discussion (Misc queries) | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Discussion (Misc queries) | |||
| Conditional formatting blank cells | Excel Discussion (Misc queries) | |||
| conditional formatting blank cell | Excel Discussion (Misc queries) | |||
Linear Mode
