• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Utilising Conditional Formatting with IF and AND formulas

F

fborg

New Member
Hi,

this is my first time posting but i've been through a few forums now in search of an answer and thought i would give this a go...


So basically, my spreadsheet has a number in A1 and another number (either a 1,2,3 or 4)in B1 and i want to conditionally format A1 such that if B1 is a "1", and A1 is less than or equal to 12, A1 turns red. If B1 is "1" and A1 is more than 12, then it stays the same.


I tried using the Conditional Formatting function, and "Use a formula to determine which cells to format" and entering: =IF(AND(B1=1,A1>=12), True, False)

but obviously that didn't work, and i don't know enough about using formulas in the CF to fix it...


Am i missing something entirely here?? Any help would be greatly appreciated.


thanks!


-Franky
 
Hi Franky ,


Place the cursor in A1 , which is the cell you wish to have the conditional formatting in.


Click on Conditional Formatting


Click on New Rule


Click on Use a Formula to determine which cells to Format


In the Formula Box , enter the following formula :


=AND(B1=1,A1<=12)


Click on Format


Select the Fill color of your choice


OK.


Narayan
 
Wow, thank you so much Narayan! you have just saved my life today like you wouldn't believe!


You are indeed an excel Ninja :)


-F
 
You must log in or register to reply here.
Back
Top