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

Conditional formatting based on numbers in columns 5
Apply formatting through code 5
Time Calculations Help 4
Conditional Formatting macro: simple, but doesn't work 6
4 conditional format 2
length of line depending on the value of the cell 13
Change a cell's color based on return value of a formula 4
Conditional formatting using text 2

Top