Need help with code for IF Than statment.

[extremecorvette]

Need help with code for IF Than statment.


What I have is in column D I have a drop down box for Visual, Hidden. I need the statment for:
If Column D = Visual Than value in column F < 550 turn cell red
If Colunm D= Hidden than value in column F <650 turn cell red

 

[T. Valko]

Need help with code for IF Than statment.


What I have is in column D I have a drop down box for Visual, Hidden. I need the statment for:
If Column D = Visual Than value in column F < 550 turn cell red
If Colunm D= Hidden than value in column F <650 turn cell red

Are you looking for a VBA solution to this or something else like conditional formatting?

 

[extremecorvette]

Yes using VBA

 

[extremecorvette]

Use conditional formatting and enter these formulas:
=AND(D1="Visual",F2<550)
=AND(D1="Hidden",F2<650)
<!-- / message --><!-- sig -->