Welcome guest. Before posting on our computer help forum, you must register. Click here it's easy and free.

Recent Posts

Pages: 1 2 [3] 4 5 ... 10
21
Computer software / Re: Excel - Conditional formating is displaying cell contents
« Last post by tigeron on September 20, 2018, 09:18:51 AM »
I just tried using Formula in conditional formatting with the same result.
Once the formatting is applied, cell contents in H9 are displayed even
with F7 being a open string.  So I am still at a loss.  Can anyone help?
22
Computer software / Re: Excel - Conditional formating is displaying cell contents
« Last post by tigeron on September 20, 2018, 08:47:43 AM »
I guess that I should add that the cell H9 color is changed based upon its own value.
color "orange" if the sum is between 1 and 50.
color "yellow" if the sum is <1.

Cell H9 has a initial background color but I don't think that matters concerning the problem.

In reading some way back posts, it seems if I use Formula instead of Cell Value in the conditional
formatting, that it might work.  That is that cell H9 does not display anything until F7 has a entry,
either text or a number.
23
Microsoft DOS / Re: Is possible to install MS-DOS to GPT disk?
« Last post by MIRKOSOFT on September 20, 2018, 05:36:45 AM »
Ok - so it is not possible override...

Thank you, we can close this thread.
Miro
24
Microsoft DOS / Re: Is possible to install MS-DOS to GPT disk?
« Last post by BC_Programmer on September 20, 2018, 05:08:35 AM »
Is possible to install this MS-DOS to GPT disk?
No.

Quote
I don't need and want not use UEFI. It will boot from BIOS... so, here's also Q if will XP work on GPT disk...
Drives partitioned via GPT can only be booted via a UEFI BIOS and the Operating systems have to support UEFI.
25
Microsoft DOS / Is possible to install MS-DOS to GPT disk?
« Last post by MIRKOSOFT on September 20, 2018, 04:32:22 AM »
Hi!

I need to use GPT disk instead MBR.
I want to have there installed MS-DOS 7.10.

Is possible to install this MS-DOS to GPT disk?
Or will installation work after conversion from MBR to GPT disk work?

I don't need and want not use UEFI. It will boot from BIOS... so, here's also Q if will XP work on GPT disk...

Thank you for your help.
Miro
26
Windows 10 / Re: SLOW PC
« Last post by ivanoe on September 20, 2018, 03:24:36 AM »
 
  Hello again did as suggested ,and did a speed test ,not sure what i should be getting but what i am getting is about,
4 mbps  tried on several sites and they are all round about the same. dose that sound bad.i dont want to ring sky yet because it costs a fortune.    Also tried your suggestion Superdave, went through everything you said cant really tell if it as suceeded,
but will give it time
   anyway thanks again for helping me .
27
Hardware / Where to shop?
« Last post by hismaimai2000 on September 20, 2018, 03:11:54 AM »
Where do you guys recommend i buy computer parts? cheapest vs quality.
28
Windows 10 / Re: locked drive, missing files on windows 10, acer laptop
« Last post by w1lson on September 20, 2018, 02:40:53 AM »
29
Computer software / Excel - Conditional formating is displaying cell contents
« Last post by tigeron on September 19, 2018, 09:11:11 PM »
First thing is, I am still using Excel 97.  Have had no reason to upgrade.
The following formula is in cell H9 and works fine.  If cell F7 is "", nothing shows up in cell H9.
Which is exactly what I want.  If cell F7<>"", then a result is displayed in cell H9.

=IF(F7<>"",(SUM(H7:H8)+D12),D12)

The problem is when I apply conditional formatting to cell H9 to change the cell color, cell
H9 displays a result even when cell F7="".

Questions:
1.  Why is nothing displayed in cell H9 when just using the above formula?
This is not a problem because I don't want anything to be displayed until
cell F7 has something entered into it.

2.  Why after applying conditional formatting a result in cell H9 is displayed, even when
cell F7=""?

What can I do so cell H9 does not display a result after applying conditional formatting?
That is until cell F7 contains a entry.

I was thinking that using a Visual Basic macro to scan the sheet every time the Enter key
was pressed, might do the trick.  But I don't want to use a macro unless I have to.

Any help would be greatly appreciated.
30
Computer software / Re: Changing Page Setup crashes MS Paint on Windows 10
« Last post by patio on September 19, 2018, 06:13:38 PM »
What version of Paint ? ?
Pages: 1 2 [3] 4 5 ... 10