Need help with Conditional Formating...if(or( does not work....

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875
Hi, I need help with Conditional Formating.
If B1 = any value from A1 to A5 then Show in Dark Blue and then font in Black.

Please help.
Thanks
:)
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

pedie

Well-known Member
Joined
Apr 28, 2010
Messages
3,875



Sorry got it working

:)
 
Last edited:

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196
Use formula condition

=countif($A$1:$A$5,B1)>0

When applying to more than the 1 cell, make sure B1 is the first cell in the range as you select.
 

Watch MrExcel Video

Forum statistics

Threads
1,108,969
Messages
5,525,963
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top