Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting help needed
I want to copy the conditional format that I created to additional lines. I
have followed the instructions to select the cells that have the format. Then click on format painter, select the cells I want to add that condition to but it is not copying the format. I'm tracking data on a monthly basis and want to highest number to highlight on each row. My formula is: if ($e3$:$aq3$)=a3 then high light it red... |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting help needed
I would recommend that you go to the original formula and delete the $. The
"$" will lock the value so that you can't drag the formula. If you would like to freeze a column or row, then you leave the"$" in that box. "learning quickly" wrote: I want to copy the conditional format that I created to additional lines. I have followed the instructions to select the cells that have the format. Then click on format painter, select the cells I want to add that condition to but it is not copying the format. I'm tracking data on a monthly basis and want to highest number to highlight on each row. My formula is: if ($e3$:$aq3$)=a3 then high light it red... |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting help needed
I suspect your formula is more like:
=MAX($E$3:$AQ$3)=A3 and this will be applied to cell A3. You can copy this across the cells in row 3 and it will work, but if you try to copy the format to another row it will not, as it will always be looking at row 3. Try changing the formula to: =MAX($E3:$AQ3)=A3 with A3 selected. Then use the Format Painter to apply this format to other cells as required. Hope this helps. Pete On Sep 10, 7:20 pm, learning quickly <learning wrote: I want to copy the conditional format that I created to additional lines. I have followed the instructions to select the cells that have the format. Then click on format painter, select the cells I want to add that condition to but it is not copying the format. I'm tracking data on a monthly basis and want to highest number to highlight on each row. My formula is: if ($e3$:$aq3$)=a3 then high light it red... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Another Conditional Formatting Formula needed? | Excel Worksheet Functions | |||
Formula or Conditional Formatting Help needed. | Excel Worksheet Functions | |||
Formatting help needed | New Users to Excel | |||
Advanced Conditional Formatting Ideas Needed! (ok, maybe not that advanced...) | Excel Discussion (Misc queries) | |||
Help needed with conditional formatting and adjacent text | Excel Worksheet Functions |