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 bkrike 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
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

Swi
  • Locked
  • Question
Excel Webservice
Replies
2
Views
536
mintjulep
M
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
481
SkipVought
S
bkoopers
  • Locked
  • Question
Problem with Excel pasting into filtered cells
Replies
1
Views
325
combo
combo
BugZap13
  • Locked
  • Question
Excel formula to count occurrences of a value in a different sheet
Replies
5
Views
913
bs6600
bs6600
renigar
  • Locked
  • Question
Having trouble with Excel Lookup
Replies
5
Views
895
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top