Benches Uncategorized

3

Change formatting based on another cell w…

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

I have a column containing a date. If another column contains the value of "1" I want to have the text formatting of the date change to strikethrough and/or the color red. I'm stuck because the content in each cell is a different type of value.

I was trying to see if an If/Then would work, but I can't see how to change formatting based on the output.

I'm using Numbers 5.3.

3 replies

Sign in or join Beachball Help to reply.

  1. 0

    jaxjason

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    There is a way of doing something like this. I cannot add a screen shot as i am not doing this at home, but off the top of my head.

    Assume:

    column A has your dates.

    Column B has the 1 or some other value.

    Column at C (new column) will have a formula that will test if B is equal to 1, Yes C1=A1, no C1=0

    Example:

    A1= 1/1/2019

    B1= 1

    C1= IF(B1=1,A1,0)

    now set your conditional highlight for A1, and choose Equals as the logic choice, where you can click to select a cell click and choose C1. choose your format options. Finish as normal.

    This will make the test when A1 is equal to C1 use the format if it is not don't.

    If anyone can put this into a screen shot to better demonstrate, it would be greatly appreciated. If i dont see it posted later, i will try to do it sometime tonight.

    Jason

  2. 0

    jaxjason

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    For anyone wanting step by step instructions on setting conditional highlighting Here is the link to apples instructions:

    https://support.apple.com/kb/PH17079?viewlocale=en_US&locale=en_US

    Jason

  3. 0

    Michael Hoffman4

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Thank you! You made it very simple. That was perfect.