Conditional Formatting

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
 
P

Pete_UK

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:

=A1>E1

Then set your format colour.

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

Hope this helps.

Pete
 
E

Esra

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

Anyway, I dsorted the problem for myself.

Thanks anyway
Esra
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top