Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Formula
I'm trying to conditionally format a rows of cells in comparison to a set row
of cells. That is, if A31.25*O3 or if O31.25*A3 format the value of A3 red and bold. Then, if B31.25*O3 or if O31.25*B3 do the same, and on and on. It's comparing monthly figures to year averages. I've tried several methods and haven't had any luck! Any body know the secret? Thanks! -- David Harmon Evans |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Formula
Select A3 and all other target cells in row 3
Goto to CF, menu FormatConditional Formatting Change Condition 1 to Formula Is Add a formula of =OR(A31.25*$O3,$O31.25*A3) Click Format Select Pattern tab Choose a highlight colour OK OK -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "DHEvans333" wrote in message ... I'm trying to conditionally format a rows of cells in comparison to a set row of cells. That is, if A31.25*O3 or if O31.25*A3 format the value of A3 red and bold. Then, if B31.25*O3 or if O31.25*B3 do the same, and on and on. It's comparing monthly figures to year averages. I've tried several methods and haven't had any luck! Any body know the secret? Thanks! -- David Harmon Evans |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting based on text within a formula | Excel Worksheet Functions | |||
conditional formatting: problem entering EOMONTH formula... | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Need conditional formatting formula to highlight top ten values i. | Excel Worksheet Functions | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) |