Background color change, by using the formula.

  • Thread starter Sarveshwar Trangadia
  • Start date
S

Sarveshwar Trangadia

I want to change the background color of the cell by using conditional formula.
like...
Cell A1's Background color should be
Red, if B1>C1
Black, if B1=C1 &
Green, if B1<C1.
 
C

carlo

Select A1
Go to Format --> Conditional Formatting...
Choose Formula is and enter: =B1>C1
format your background by clicking on format...
then add a rule and change to Formula is and enter:
=B1=C1 and format the background.
and then last but not least add the last rule, change
to formula is and enter: =B1<C1

hth

Carlo
 

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

Changing row background from external program 0
Conditional formatting based on numbers in columns 5
VBA Coding Help for Beginner 0
If, Or, and 5
Time Calculations Help 5
Apply formatting through code 5
GridLines Inadvertantly Goes Away with Macro 3
Conditional Formatting macro: simple, but doesn't work 6

Top