Conditional Formatting Or Function Two Colors

nburaq

Board Regular
Joined
Apr 2, 2021
Messages
93
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Hi Gents,
Is there any way to give two different colors for each condition for conditional formatting? Like =OR (E1>0; E1<0) then values less than "0" will be red highlighted and values greater than "0" green ?
Thanks for comments and help!
 

Excel Facts

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
14,560
Office Version
  1. 365
Platform
  1. Windows
You can create multiple conditions for the same range. In your case, you would use one for =E1>0 (green) and another for =E1<0 (red).
 
Solution

nburaq

Board Regular
Joined
Apr 2, 2021
Messages
93
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
You can create multiple conditions for the same range. In your case, you would use one for =E1>0 (green) and another for =E1<0 (red).
Thanks for the help.So basically, I need to create two conditional rules via conditional formatting ? but it only lets me to create per sheet ? Or am i missing something ?
 

jasonb75

Well-known Member
Joined
Dec 30, 2008
Messages
14,560
Office Version
  1. 365
Platform
  1. Windows
You can add as many as you need. Home > Conditional formatting > Manage rules.

Excel 2003 (or older) had a limit of 3 rules for any given range. As far as I know, versions from 2007 onward are unlimited (possibly limited by computer memory, etc. but it would be big numbers).

If you're using a program other then Excel then there may be different restrictions.

 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
18,163
Office Version
  1. 2013
Platform
  1. Windows

ADVERTISEMENT

Thanks for the help.So basically, I need to create two conditional rules via conditional formatting ? but it only lets me to create per sheet ? Or am i missing something ?
If your wanting the same conditional formatting in numerous sheets same column
Just copy the column in sheet1 and paste to same column in sheet2 and on and on as many sheets as you want.
Or we write some vba code to do it.
 

nburaq

Board Regular
Joined
Apr 2, 2021
Messages
93
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
Thanks a lot! Again my problem is solved and again such a wonderful community! (y)
 

My Aswer Is This

Well-known Member
Joined
Jul 5, 2014
Messages
18,163
Office Version
  1. 2013
Platform
  1. Windows
Thanks a lot! Again my problem is solved and again such a wonderful community! (y)
How did you solve it?

If you want to just copy conditional formatting into column and not the values.
I have a Vba script to do that.
Especially if you want this in several sheets
 

nburaq

Board Regular
Joined
Apr 2, 2021
Messages
93
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
How did you solve it?

If you want to just copy conditional formatting into column and not the values.
I have a Vba script to do that.
Especially if you want this in several sheets
It could be nice if you can share vba script as well. Here is the solution it works for me;
Conditional_Fromatting.png
 

Forum statistics

Threads
1,148,237
Messages
5,745,555
Members
423,959
Latest member
Bismarkmensah

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top