Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

If statement

Comment:

Is there a way to write an if statement that will make a cell turn a specific color? For example, if the word yes appears in cell b3, b2 turns red.

Name: DerbyDad03
Date: March 12, 2009 at 13:34:19 Pacific

Reply:

Use Conditional Formatting Select B2 Click Format...Conditional Formatting Pull Dropdown to Formula Is... Enter =IF(B3="Yes",TRUE,FALSE) Click the Format button, choose the Patterns tab, pick your color.

0

Outlook 2003

Outlook Access

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: I have 3 entries generated by if statements in 3 cells next to each other. D1, E1, F1. Based on the IF statement outcomes, only one of these cells will show a value. For instance, D1 will show "FALSE"...

Summary: =IF(AND(A3-TODAY()<30,F3=""),"Request ET","Ok") =IF(AND(F3<>"", TODAY()>=F3+30), "Re-Request ET", "Ok") =IF(AND(A3-TODAY()<7,AND(J3<>"", H4="")), "Chase", "Ok") The above are 3 seperate IF...

Summary: Hi, I was wondering if someone could help me get an Excel IF statement right. I am making a test, and I need to convert the raw score into a standard ten. Basically, I need a formula that says IF the ...