XAO
Click for more information
0.56% 8,612.6 all ordinaries

Hi Rick,1. Select the range of cells you want to colour code2....

  1. ColonialCousin
    286 Posts.
    lightbulb Created with Sketch. 73
    clock Created with Sketch.
    15/01/19
    14:49
    Post #: 37120694
    Hi Rick,


    1. Select the range of cells you want to colour code

    2. Select Conditional Formatting from Home menu

    3. Select Use Formula to ..... option

    4. Enter =AND($N5>=0, $N5<>"") in the formula box

    5. Click format

    6. Choose your formatting

    Done.

    Repeat above for negative gains by using "=$N5<0"


    Please do not take me wrong biggrin.png, but I think it would be better to ask these type of excel questions at the spreadsheet help forum, as this is not an STT matter. I do not mind answering if you tag me smile.png


    Last edited by ColonialCousin: 15/01/19
    XAO Value at posting: 5,861.8
    Likes Created with Sketch. 3  Upvote
    lightbulb Created with Sketch. 1  Great analysis
    Stroke 3 Created with Sketch. Comments Created with Sketch. Reply

  2. Top Stories

 
watchlist Created with Sketch. Add XAO (ASX) to my watchlist
(20min delay)
Last
8,612.6 		Change
-48.600(0.56%) 		Mkt cap ! n/a
Open High Low
8,661.2 8,682.0 8,606.8
XAO (ASX) Chart
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.