Conditional Formatting
 

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

Conditional Formatting
 

Highlight all the cells before you set the conditional formatting. In
the CF box select Formula Is rather than Cell Value Is and then enter
this formula:

=A1E1

Then set your format colour.

Excel will automatically apply the same condition to the other
highlighted cells.

Hope this helps.

Pete

On Apr 27, 12:16*pm, Esra wrote:
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

Conditional Formatting
 

Sorry, screwed that post up, attaching i t to another one it looks
like.

Anyway, I dsorted the problem for myself.

Thanks anyway
Esra



On Sun, 27 Apr 2008 23:16:35 +1200, Esra wrote:

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

Conditional Formatting
 

You're welcome.

Pete

On Apr 27, 1:07*pm, Esra wrote:
Sorry, screwed that post up, attaching i t to another one it looks
like.

Anyway, I dsorted the problem for myself.

Thanks anyway
Esra