How to use IF statement??

  • Thread starter Thread starter garry
  • Start date Start date
G

garry

Hi...
Can't seem to figure out how to use (IF). Let's say that if A5 data
is less than 20, then I want B5 to be light-blue with the word "LOW".
If A5 is greater than 30, then I want B5 to be pink and the word "HIGH"
appears. If no data is in A5 (or if the data is between 20 & 30), then
B5 is white. In other words, I only want an argument response (blue or
pink) when A5 is out of range. I'm using only A5 here, for
explanation, but there will be a number of rows. Can someone help me
with the proper syntax for the formula, and where to install it (A5?
B5?)? Caution: Please understand that I'm somewhat of a dummy with
Excel...I can use it to an extent, but this has me stumped.

Thanks in advance for your help,
Garry
 
High Garry!

Two steps:

Formula in B5:
=IF(A5="","",IF(A5<20,"LOW",IF(A5>30,"HIGH","")))
Copy down as appropriate

Now select B5 and use:

Format > Conditional Formatting
Cell Value Is
Equal to
="LOW"
Format Button
Pattern Tab select your blue
OK
Add Button
Cell Value Is
Equal to
="HIGH"
Format button
Select your red
OK
OK

To do a whole range of cells like this, select the range of cells and
use the process above.
 
Back
Top