Conditional Formatting ?????????

[aallard]

Is there a way with (excel 2000) where a cell meets a certain value (ie: 1 or 2) then the whole row turns a certain color...??? Conditional formatting seems to work only for that cell...

[anilsolipuram]

you have to use macro

if range("a1").value="1" then
rows("1:1").select
With Selection.Interior
.ColorIndex = 15
.Pattern = xlSolid
.PatternColorIndex = xlAutomatic
End With
end if

[AlfD]

Hi!

You can apply conditional formatting to each cell in a row so that each changes if the chosen cell satisfies a given condition. But if you have many such cells probably go for VBA.

Alf