LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Change conditional formatting if the number is odd or even?

How do I do a conditional formatting option based on if the number in the referenced cell is odd or even? For example, if the cell is 16, text color it black, if the cell is 15, text color it red.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting does not change when values change. ?? Texana Excel Worksheet Functions 4 August 20th 07 12:20 AM
How do I use Conditional Formatting to change pos No to a Neg No Wannabegeek Excel Discussion (Misc queries) 1 August 6th 07 04:49 AM
whole number conditional formatting danlinksman Excel Worksheet Functions 9 April 24th 07 12:50 AM
Change conditional formatting to coloured alternate rows dependent on a change in date? StargateFan[_3_] Excel Programming 4 August 2nd 06 11:28 AM
Conditional Number Formatting Neda Excel Discussion (Misc queries) 2 December 20th 05 02:39 AM


All times are GMT +1. The time now is 06:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"