conditional format cells colours based on an other cell

[mickgibbons1]

hi guys

i have a spreadsheet that contains a lot of information, i am after changing the colour of a range of cells based on one cell

i have a cell that counts down between two dates using this formula =DATEDIF(C5,D6,"d")

once that cell gets down to zero it shows num!

i can that get that cell to colour red using conditional format when cell shows an error, however the big question is how do i get it to colour the row and not just that once cell

thanks guys

[FDibbins]

Use "use formula" and apply it to the entire range. Make sure you partial-absolute the cell ref though, something like $A1.

Note also, that if you haved a LOT of data, CF can slow things down a bit

[Tony Valko]

how do i get it to colour the row and not just that once cell

Tell us exactly which cells you want to apply the formatting to and which cell contains the formula.

[mickgibbons1]

Tony

A6 - E6

the formula is in E6, (which shows Num! once date counted down

[mickgibbons1]

Fdibbens

i have a lot going on in the spreadsheet, but lucky its a info based spreadsheet and does not get updated that much

[FDibbins]

OK. did you try my suggestion?

[Tony Valko]

Try this...

Select the *entire* range A6:E6 starting from cell A6.
Cell A6 will be the active cell. The active cell is the
one cell in the selected range that is not shaded. The
formula will be relative to the active cell.

Goto the Home tab>Styles>Conditional Formatting>
Manage rules>New rule>Use a formula to determine
which cells to format

Enter this formula in the box below:

=ISERROR($E6)

Click the Format button
Select the desired style(s)
OK out

[mickgibbons1]

mate i understand i need to do a formula but i am not sure how that will go

[Tony Valko]

mate i understand i need to do a formula but i am not sure how that will go

Can't tell who you're replying to?

[mickgibbons1]

tony, Fdibbens

thank you both for your replays and help, works great. thank you

[mickgibbons1]

tony,

sorry mate your formula worked a treat thank you for taking the time to help

[Tony Valko]

You're welcome. Thanks for the feedback!

[FDibbins]

Happy to help