Not a valid bug report.

I can't remember to have seen something like that with "LibreOffice 3.5.4.2  German UI/Locale [Build-ID: 165a79a-7059095-e13bb37-fef39a4-9503d18] on German WIN7 Home Premium (64bit) 

@reussandras@gmail.com 
Thank you for your report – unfortunately important information is missing.
May be hints on <http://wiki.documentfoundation.org/BugReport> will help you to find out what information will be useful to reproduce your problem? If you believe that that  is really sophisticated please as for Help on a user mailing list
Please:
- Write a meaningful Summary describing exactly what the problem is
- Attach a sample document (not only screenshot) or refer to an existing 
  sample document in an other Bug with a link.
- Contribute a document related step by step instruction containing every 
  key press and every mouse click how to reproduce your problem 
  (similar to example in Bug 43431)
- add information 
   -- concerning your PC 
  -- concerning your OS (Version, Distribution, Language)
  -- concerning your LibO UI language, Locale setting
  –- Libo settings that might be related to your problems 
  -- how you launch LibO and how you opened the sample document
  -- everything else crossing your mind after you read linked texts

Even if you can not provide all demanded information, every little new information might bring the breakthrough.

May be you can test <https://www.libreoffice.org/get-help/bug/> for submitting bug reports? You reach that Bug Submission Assistant via LibO menu 'Help -> Feedback / Bug Report'

Created attachment 62949 [details]
a sample to work on

In the attached document, I can change the value in G2, but the range formatting does not change, only on keypress F9 or something that needs a screen refresh.

Dear Bug Submitter,

This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INVALID due to lack of needed information.

For more information about our NEEDINFO policy please read the wiki located here: 
https://wiki.documentfoundation.org/QA/FDO/NEEDINFO

If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed.


Thank you for helping us make LibreOffice even better for everyone!


Warm Regards,
QA Team

I can confirm reproducible on LO 4.0.3.3 (Win7 32bit)

Changing cell G2 to 1000 isn't updating cells C2:D10 format. Changing applied after clicking save.

(In reply to comment #4)
> I can confirm reproducible on LO 4.0.3.3 (Win7 32bit)
> 
> Changing cell G2 to 1000 isn't updating cells C2:D10 format. Changing
> applied after clicking save.

So we can mark it as NEW.

CC'ing our conditional formatting expert :), Markus

Created attachment 90616 [details]
Cells with conditional format in copied sheet are not refreshed automatically

Presumably a slightly different manifestation of this bug
(LO 4.1.3.2 Windows 7 - 64)

In sheet Sh1, cells A1:A8 have a red background if A1 contains a negative value.
Conditional format works as expected.

Sh2 was created as a copy of Sh1 (right click on tab)
On modification of A1, the background of A2:A8 remains unchanged.

Some actions restoring proper display :
-- ctrl+shift+F9 (not F9 by itself)
-- moving or redimensioning the window
-- going to and from another sheet...