How to do a macro for IF cell b1 is < b3 turn b1 red?

G

Guest

I am trying to figure out on excel if Cell B1 is < Cell B2 then I would like
to turn B2 cell words or the cell to red. how can this be done?
 
G

Gord Dibben

Glenn

Select B2 and Format>Conditional Formatting>Cell Value is:

Less than........=B1

Format to a red pattern and ok your way out.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Referencing a cell even if its contents are moved moved/replaced 6
=B2-B1 becomes B3-B2 for fill right and I want B3-B1 then B4-B1. 2
Excel In Excel how can I block the contenent of a cell? 0
How do I set conditional formatting relative to another cell -XL20 2
How to do - B2 is only valid if B1 is zero 1
Help to create a macro 2
How to display a value in say B2 in B3 IF a value in B1 is true 11
Conditional Formatting with if statement 1

Top