Add color to the formula answer

  • Thread starter Thread starter israel
  • Start date Start date
I

israel

2 collumns with numbers, what would be a formula to identify which is less
and the answer of "TRUE" should be in color blue and false should be red?
 
Are you wanting to know which is less, or if column 1 is less than column 2?
What if the numbers are equal? If this is not an issue, and assuming numbers
are in columns A and B

Formula in C2:
=IF(A2>B2,TRUE,FALSE)

Then go to format -> Conditional formating
First condition if cell value = TRUE, then pick blue pattern. Add condition
for if cell value = FALSE with a red pattern.
 
Use conditional formating by using formulas in the conditional formating.

Select the first column range of numbers and select Format>Conditional
Formating...

Change the "Cell Value Is" to "Formula Is" for each condition. Enter
=$I4>$J4 in the input box. Add another condition "Condition 2" and enter
=$I4<$J4 in that input box. Set your format for each.

When done select the second column range of numbers and select
Format>Conditional Formating... again.

Change the "Cell Value Is" to "Formula Is" for each condition. Enter
=$I4>$J4 in the input box. Add another condition "Condition 2" and enter
=$I4<$J4 in that input box. Set your format for each.

The cell address I have indicated are examples only. Of course you will have
to enter the top cell address of your column of numbers for this to work.
Also keep in mind the arrow keys do not move the cursor in the input box and
the F4 absolute reference shortcut key does not work here either. You will
have to manually remove the $ from the row value in the formula. Doing this
will cause migration of the formula down the rows in each column, saving the
time to do each cell separately.
 
Back
Top