How To Get Confiscated Ids Back

conditional functions = IF complex nested IF functions

Tepas makes the following query: How do

with IF function and conditional formatting in a column that contains text and another that prices in a third cell to show me the red if I start with A1 or B1 is greater than 1400, otherwise show the color YELLOW. I hope I can help. Happy Day

In this case we must first build the = YES and then apply conditional formatting.

= IF function is:
= IF (OR (MID (A1, 1, 1) = "I" B1> 1400), "YES" "NO")

operator O ago enforcing a condition or the other.
just
The MID function extracts characters from a string. The idea in this example is to identify words that begin with the letter I in column A.

words YES and NO may be the condition and identify any true and false = IF function is just a trick to then apply conditional formatting.

now is tell the conditional formatting to paint red cells that say YES and yellow ones that say NO. But as the same time to delete the words YES and NO because Karen does not need and just want to color the shaded cells, we resorted to another trick.

choose Conditional Formatting Cell Value Is equal to YES and format, both in filling and in Source select the same color red. In this way the letters are mixed with the background. The same then for Cell Value equals NO and yellow.



Finally, what we wanted:

Gou