conditional formatting more than 3 conditions

G

Guest

Guest
I have column A conditional formatted as =D1=1, but I need to be able to compare it to 10 different number in D1, how can this be done, I am using excel '97. thanks
 

Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},$Z$1:$Z$99,$Y$1:$Y$99),2,False) to lookup Y values to left of Z values.
You will need VBA for more than Three conditions. I seem to recall that Dave Hawley had some code for this on his web site at OZGRID.com
 
Upvote 0
Do you want the whole column to change color when D1 changes or do you want
A1 to change when D1 changes
A2 to change when D2 changes
and so on
 
Upvote 0
Hi

Ok i do not like to post my VBA Scripted codes as most dont understand my odfd programming, However this i have developwed over time, to colour the whole row which i wanted subject to Col m anywher reading K, thisits does FAST!

I owe Dave Hawley a big ti[p of the hat as really he set the seeds on this one and this is his style of programming, it never fails me, i use this bit MUCH bigger 25 conditions not just row colour easy to convert or edit to WHATEVER.

Everopne will what this its that goos just add section but section to add conditions as you like,

Cheers Dave Hawley http://www.ozgrid.com

.........
Sub Rows_Color()
On Error GoTo Z
Sheets("Sheet1").Select
Range("A1:R500").Select
Selection.Interior.ColorIndex = xlNone
Range("A1").Select
Application.ScreenUpdating = False
Rw = 1
'>>>>>>>>>>>>>>>>>>>>
With Sheets("Sheet1") 'Jack in the UK
For K = 1 To WorksheetFunction.CountIf(.Columns("M:M"), "K")
Set RKateFoundCell = .Columns("M:M").Find(What:="K", _
After:=.Cells(Rw, 13))
RKFoundCell.EntireRow.Interior.ColorIndex = 4
Rw = RKFoundCell.Row
Next K
End With
'>>>>>>>>>>>>>>>>>>>>>

'>>>>>>>>>>>>>>>>>>>>>
Columns("R:IV").Select
Selection.Interior.ColorIndex = xlNone

Application.Goto Reference:="R1C14"
Application.ScreenUpdating = True
Z:
End Sub
..............

These is the base to any conditional format problems !
 
Upvote 0
Tommy i need
A1 to change when D1 changes
A2 to change when D2 changes
and so on
Thanks
 
Upvote 0

Forum statistics

Threads
1,213,515
Messages
6,114,080
Members
448,548
Latest member
harryls

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
Back
Top