Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Change formatting based on another cell when cell contents are different.

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.

Posted on Jan 11, 2019 9:46 AM

Reply
Question marked as Best answer

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


Posted on Jan 11, 2019 11:40 AM

3 replies
Question marked as Best answer

Jan 11, 2019 11:40 AM in response to Michael Hoffman4

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


Change formatting based on another cell when cell contents are different.

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.