Hi,

Am Sun, 4 May 2014 12:52:16 +0200 schrieb Claus Busch:

look for Conditional Formatting

or look he
https://onedrive.live.com/?cid=9378A...121822A3%21326
for "ShowDependingMessages"
There is a solution with macro. Rightlick and download the file because
macros are disabled in OneDrive


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Many thanks Claus you have been a big help, really appreciate you taking the time to help out.

cheers mate

slipper

Claus

One more thing i thought of that may be usefull to me. The conditional formatting works fine for changing a colour of a cell based on a value in that cell.

However is there any way to influence the colour of another cell based on the value in a separate cell?

for example

your RAND formula in A1. Then:

=CHOOSE(A1,"MessageA","MessageB","MessageC","Messa geD","MessageE",.........)


IF(A1 <= 4) then (A2&&A3 = green, A4 = red)
IF(A1 4) then (A2 = green, A3 = red, A4 = orange)


The above is not exactly what i want just as way of an explanation, is this possible at all? can't see a way of doing it with conditional formatting, only of changing the colour in the cell with the value in it.

Cheers again for any help.

regards

slipper

Hi,

Am Mon, 5 May 2014 11:01:05 +0100 schrieb slipper:

IF(A1 <= 4) then (A2&&A3 = green, A4 = red)
IF(A1 4) then (A2 = green, A3 = red, A4 = orange)

The above is not exactly what i want just as way of an explanation, is
this possible at all? can't see a way of doing it with conditional
formatting, only of changing the colour in the cell with the value in
it.

look again in OneDrive for the workbook. I changed the code to the above
colors.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Many thanks Claus, got it. Think i am sorted now.

Thanks for all your help, took the opportunity to download some other example aswell.

regards

slipper

Hi,

Am Tue, 6 May 2014 10:12:04 +0100 schrieb slipper:


Think i am sorted now.

always glad to help. Thank you for your feedback


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional