Select A10:N10 or the entire row 10 if desired.
FormatConditional FormattingFormula is:
=$N1025
Note the $ sign must be entered to make Column N absolute.
Pick a suitable red color from the FormatPatterns chart and OK your way out.
Gord Dibben Excel MVP
On Tue, 28 Dec 2004 16:27:02 -0800, "Wes T" <Wes
wrote:
I want to format a row based on the value of another cell. eg If cell N10
25 then fill (hi-light) row 10 (or A10:N10) with red colour.