Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting issue
I am using Excel 2003 and have a table where the bottom number shows an
average of the rows above. I want to conditionally format the numbers that are below the average as it changes. Is there something that I can put in the cells containing the values that I am averaging which will conditional format them if they are lower than the average? Thank you, Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting issue
With your numbers in b1:b9 and your average in b10, select b1:b9 and
Format/Conditional Format, change to formula is and try this formula: =B1<$B$10 then change the format to what you want to see. -- Kevin Vaughn "QUESTION-MARK" wrote: I am using Excel 2003 and have a table where the bottom number shows an average of the rows above. I want to conditionally format the numbers that are below the average as it changes. Is there something that I can put in the cells containing the values that I am averaging which will conditional format them if they are lower than the average? Thank you, Mark |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting issue
Yes!! That worked. Thank you for your time.
Mark |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formatting issue
You are welcome. Glad it helped.
-- Kevin Vaughn "QUESTION-MARK" wrote: Yes!! That worked. Thank you for your time. Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
conditional formatting question | Excel Discussion (Misc queries) | |||
Conditional Formatting in Excel Help Please..... | Excel Discussion (Misc queries) |