Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #111038

Re: Mark cell with a color based on 2 values setup in a text with a sign in between

Show all headers | View raw

Hi Johan,

Am Sat, 20 Jul 2019 01:26:02 -0700 (PDT) schrieb JS SL:

> I've got a sheet with several columns and rows.
> A system output shows were the data is changed with the shown combi of "old -> new". If the data is changed from empty to something of from something to empty then it shows '-'
> 
> The format is always the same
> For example;
> 
> 200,000 -> 210,7
> '-' -> 200
> 202,1 -> '-'
> 150 -> 140
> 
> What is the question... (challange);
> 
> I need to mark the cell;
> 
> red = if the value right = higher then the value left side (200,000 -> 210,7).
> green = if the value right = lower then the value left side (150 -> 140).
> bleu = if there was a value left side but now right it is '-' (202,1 -> '-').
> orange = if there was  '-' left and now right side it is a value ('-' -> 200) 
> no coloring if the cell is empty of left/right is identical.

that's easily done with conditional formatting.
Download the demo from here:
https://1drv.ms/x/s!AqMiGBK2qniTgeVn4tYccT2EFxjAEA?e=cTNkQz
and have a look for the rules of the conditional formatting.


Regards
Claus B.
-- 
Windows10
Office 2016

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Mark cell with a color based on 2 values setup in a text with a sign in between JS SL <jmslab@xs4all.nl> - 2019-07-20 01:26 -0700
  Re: Mark cell with a color based on 2 values setup in a text with a sign in between Claus Busch <claus_busch@t-online.de> - 2019-07-20 11:25 +0200
    Re: Mark cell with a color based on 2 values setup in a text with a sign in between JS SL <jmslab@xs4all.nl> - 2019-07-20 03:04 -0700
      Re: Mark cell with a color based on 2 values setup in a text with a sign in between Claus Busch <claus_busch@t-online.de> - 2019-07-20 12:56 +0200

csiph-web