Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Conditional Formatting in Excel

Status
Not open for further replies.
sdrp

sdrp

MIS
Nov 7, 2003
13
0
0
GB
Hi,

Does anyone know if it's possible to add more than 3 contraints to the conditional formatting function in Excel?

Cheers
 
Sort by date Sort by votes
do you know if there is any other way around this, without adding a macro?

thx
 
Upvote 0 Downvote
You can have 4 conditions as no condition is on and then 3 conditions.

Search this forum and there is ode for doing more than this



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com
 
Upvote 0 Downvote
Found it

thread68-223068



Neil Berryman
IT Trainer
neil_berryman@btopenworld.com
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bijugate
  • Question
Excel update question
Replies
0
Views
100
Bijugate
Bijugate
Pirouette
  • Locked
  • Question
Excel workbook
Replies
1
Views
128
combo
combo
Andyri
  • Locked
  • Question
Limits in Excel 2
Replies
7
Views
99
Andyri
Andyri
arvarr
  • Locked
  • Question
Excel Formula Help 1
Replies
7
Views
150
SkipVought
S
M
  • Locked
  • Question
Excel Power Query
Replies
4
Views
128
combo
combo

Part and Inventory Search

Sponsor

Back
Top