Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 28th 06, 09:09 PM posted to microsoft.public.excel.misc
guilbj2
 
Posts: n/a
Default Multiple conditions in Conditional Formatting


I'm currently using the following as conditions 1 and 2 for a custom
format that alternates the shading every other line.

What I can't figure out, is how to add another condition. Basically, I
want to check column M for a Y or N value. If Y if present, I want the
text to be green. If a N is present, red text.

I can do the Y/N bit just fine, but can't seem to do it at the same
time as the alternating shading.

=MOD(SUBTOTAL(3,OFFSET(A$8:A4,0,0)),2)=0
=MOD(SUBTOTAL(3,OFFSET(A$8:A4,0,0)),2)=1


--
guilbj2
------------------------------------------------------------------------
guilbj2's Profile: http://www.excelforum.com/member.php...fo&userid=6043
View this thread: http://www.excelforum.com/showthread...hreadid=556652


Reply
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 Rich Excel Discussion (Misc queries) 2 April 1st 06 10:27 AM
I have more than 6 conditions when using conditional formatting? Magda Excel Worksheet Functions 3 March 1st 06 09:15 AM
Conditional Formatting when inserting a row zahoulik Excel Worksheet Functions 2 January 7th 06 03:01 PM
Multiple Column Conditional Formatting Colleen New Users to Excel 2 September 9th 05 09:15 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM


All times are GMT +1. The time now is 02:08 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017