E
Esra
I use excel 2007 and have a small table.
I wish the cells in column A to be coloured depending on the result of
the cells in column E (A1 depending on e1 value, a2 depending on e2
value etc)
How do i 'fill' the cells down the column, using the same condition,
without the $ signs in the formula?
using simple formula, if e is > d then colour, true,false but cant
drag formula coz $ sign is there and wont go away.
any help? dont want to have to keep writing condition each row.
Esra
I wish the cells in column A to be coloured depending on the result of
the cells in column E (A1 depending on e1 value, a2 depending on e2
value etc)
How do i 'fill' the cells down the column, using the same condition,
without the $ signs in the formula?
using simple formula, if e is > d then colour, true,false but cant
drag formula coz $ sign is there and wont go away.
any help? dont want to have to keep writing condition each row.
Esra