Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting | Excel Worksheet Functions | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |