Conditional frmatting issue
This should be simple so I must be over thinking the problem.
I want to set a conditional format to set a cell fill if the number in Cell A1 is an even number. |
Conditional frmatting issue
Formula is:
=MOD(A1,2)=0 (if A1 is the activecell) "Patrick C. Simonds" wrote: This should be simple so I must be over thinking the problem. I want to set a conditional format to set a cell fill if the number in Cell A1 is an even number. -- Dave Peterson |
Conditional frmatting issue
Hi,
You can also use the ISEVEN(cell_ref) formula in condition formatting -- Regards, Ashish Mathur Microsoft Excel MVP www.ashishmathur.com "Patrick C. Simonds" wrote in message ... This should be simple so I must be over thinking the problem. I want to set a conditional format to set a cell fill if the number in Cell A1 is an even number. |
Conditional frmatting issue
Hi,
=MOD($A$1,2)=0 Note - if you want to set more than one cells colors based on A1 you will need to include the $'s. the answer one might want is (and will work in 2007) =ISEVEN(A1) However, ISEVEN is part of the Analysis ToolPak and in 2003 that is a separate file which Excel won't let you reference directly. The workaround in 2003 other than using MOD, which is good, is to define a name E which Refers to =ISEVEN($A$1) and then choose Format, Conditional Formatting, pick Formula is from the 1st drop down and enter =E click the Format button and pick a color. -- If this helps, please click the Yes button Cheers, Shane Devenshire "Patrick C. Simonds" wrote: This should be simple so I must be over thinking the problem. I want to set a conditional format to set a cell fill if the number in Cell A1 is an even number. |
Conditional frmatting issue
1.Select cell A1
2.Select formatconditional formatting from the menubar 3.In the dialog box, select formula is from the drop down list to the left 3.Now in the box to the right and enter following =MOD($A$1,2)=0 4.Click format button, choose color and click OK Now you are done Have a nice time Chris ------ Convert your Excel spreadsheet into an online calculator. http://www.spreadsheetconverter.com -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200902/1 |
All times are GMT +1. The time now is 01:12 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com