Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 3 cells Skipping the center cell
I'd like to conditionally format O5,O6 andO7
O5,O6 and O7 to change color based on the "number in O7" Note: There will be figures in O5 and O6 which "I need to disregard". if O7 is Less than 0(zero If O7 is greater than 1 But I'd like all 3 cells to follow the number in O7 Can that work Thank you Mark |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 3 cells Skipping the center cell
Hi Mark,
select the three cells, do conditional formating where the formula is =O71 choose your color =O7<0 choose your color "Mark" wrote: I'd like to conditionally format O5,O6 andO7 O5,O6 and O7 to change color based on the "number in O7" Note: There will be figures in O5 and O6 which "I need to disregard". if O7 is Less than 0(zero If O7 is greater than 1 But I'd like all 3 cells to follow the number in O7 Can that work Thank you Mark |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 3 cells Skipping the center cell
And make both O7 references absolute ($O$7).
Eduardo wrote: Hi Mark, select the three cells, do conditional formating where the formula is =O71 choose your color =O7<0 choose your color "Mark" wrote: I'd like to conditionally format O5,O6 andO7 O5,O6 and O7 to change color based on the "number in O7" Note: There will be figures in O5 and O6 which "I need to disregard". if O7 is Less than 0(zero If O7 is greater than 1 But I'd like all 3 cells to follow the number in O7 Can that work Thank you Mark |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionl format for 3 cells Skipping the center cell
Mark,
I've responded to your private email on this, although you didn't tell me what the conditions were. Pete On Feb 6, 1:57*pm, Mark wrote: I'd like to *conditionally format O5,O6 andO7 O5,O6 and O7 to change color based on the "number in O7" Note: There will be figures in O5 and O6 which "I need to disregard". if O7 is Less than 0(zero If O7 is greater than 1 But I'd like all 3 cells to follow the number in O7 Can that work Thank you Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
Conditionl format for 1 cellthat looks at 3 cells. | Excel Worksheet Functions | |||
Conditionl format a cell to change text colour | Excel Discussion (Misc queries) | |||
conditionl format overrides explicit format | Excel Discussion (Misc queries) | |||
Conditionl Format | Excel Worksheet Functions |