Changing cell colour based on IF Function

[jMitchell1]

I have created a spreadsheet to compare the performance of last month's social media performance with this month's.

For my data, I have used the IF function. Although this is working with symbols and text, I want it to change the colour of the cell based on the data from the cells that are part of the IF function.

My current formula is:

=if(B3<C3,"?","?")

Is it possible to have the value_if_true and value_if_false change the colour of the cell, so I wouldn't have to use the symbols I have chosen?

Also, I want this to change automatically based on the data that I put into the cells B3 and C3 every month. Therefore, I don't want to have to change the colour of the cell manually.

Thanks for the help in advance.

 

[nemmi69]

you could return 1 for true, 0 for false and then use conditional formatting to set the colour based on the value. Would set an example but not sure how to show it here.

 

[njimack]

You don't need an If function - simply subtract one cell from the other and use Conditional Formatting > Icon Sets

 

[PGD15]

I have created a spreadsheet to compare the performance of last month's social media performance with this month's.

For my data, I have used the IF function. Although this is working with symbols and text, I want it to change the colour of the cell based on the data from the cells that are part of the IF function.

My current formula is:

=if(B3<C3,"","")

Is it possible to have the value_if_true and value_if_false change the colour of the cell, so I wouldn't have to use the symbols I have chosen?

Also, I want this to change automatically based on the data that I put into the cells B3 and C3 every month. Therefore, I don't want to have to change the colour of the cell manually.

Thanks for the help in advance.

From my understanding of your problem, there is only two values that could possible be entered in the selected cell?

If so, go into conditional formatting on the home ribbon, new rule...

select based on a formula and write =if(a1="symbol x",true) then select the format that you want for this value.

repeat the process for the other value and go to manage rules and click stop if true for the second value.

You just need to update the cell reference and symbol x for what ever your data is