Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting by formula
I want a special format when the cell in column E is MOD,10.375 and the cell
in column F is MOD,10.006944 I know how to write it in a regular formula, but I don't know how to create a rule description. How would enter =IF(MOD(E1,1)0.375,IF(MOD(F1,1)0.006944,ALERT,)) in "use a formula to determine which cells to format" |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting by formula
First you select the cell(s) that you want the CF to apply to, with
the active cell in row 1, then you can use the formula: =AND(MOD(E1,1)0.375,MOD(F1,1)0.006944) and then click on the format button and choose the effect that you want (eg background colour, foreground colour etc). Excel will automatically adjust the cell references for selected cells on other rows. Hope this helps. Pete On Mar 5, 12:26*am, fruitchunk wrote: I want a special format when the cell in column E is MOD,10.375 and the cell in column F is MOD,10.006944 I know how to write it in a regular formula, but I don't know how to create a rule description. How would enter =IF(MOD(E1,1)0.375,IF(MOD(F1,1)0.006944,ALERT,)) in "use a formula to determine which cells to format" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting with formula | Excel Discussion (Misc queries) | |||
Conditional formatting in a formula | Excel Discussion (Misc queries) | |||
Conditional formatting as a formula | Excel Worksheet Functions | |||
Conditional formatting formula | Excel Worksheet Functions | |||
conditional formatting formula | Excel Discussion (Misc queries) |