If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional Format
This question has probably been asked a thousand times but just scrolled
through and couldn't find it. I want to conditional format my sheet, so if there is an empty cell containing no information or data, then I would like that cell to change colour. I know to use conditional format and use a formula, but what formula? |
#2
|
|||
|
|||
Conditional Format
Hi
in conditional formatting use Value is equal to ="" and set the patterns tab to whatever you want. Cheers JulieD "Continental Translations" wrote in message ... This question has probably been asked a thousand times but just scrolled through and couldn't find it. I want to conditional format my sheet, so if there is an empty cell containing no information or data, then I would like that cell to change colour. I know to use conditional format and use a formula, but what formula? |
#3
|
|||
|
|||
Conditional Format
I knew it was something like that. I tried =IF"" but had no jou!
Thanks Julie JulieD wrote in message ... Hi in conditional formatting use Value is equal to ="" and set the patterns tab to whatever you want. Cheers JulieD "Continental Translations" wrote in message ... This question has probably been asked a thousand times but just scrolled through and couldn't find it. I want to conditional format my sheet, so if there is an empty cell containing no information or data, then I would like that cell to change colour. I know to use conditional format and use a formula, but what formula? |
Thread Tools | |
Display Modes | |
|
|