LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Conditional formatting not working with AND

I have some conditional formatting to check that a value in column CO
does not match the value in column A, and that cell should not be
blank.

If I check against column A using
=CO31<OFFSET(CO31,0,1-COLUMN(CO31))
it works fine.

If I check the cell isn't blank using
=CO31<""
it works fine.

BUT if I combine both and use
=AND(CO31<OFFSET(CO31,0,1-COLUMN(CO31)), CO31<"")
then it doesn't work.

Anyone have any ideas? Thanks.
 
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
Not working: Conditional Formatting Mel[_4_] Excel Discussion (Misc queries) 6 May 3rd 23 03:42 AM
Conditional Formatting - not working Maze[_2_] Excel Discussion (Misc queries) 0 February 10th 10 06:22 PM
Conditional Formatting Not Working Out Big Red[_2_] Excel Programming 3 June 15th 07 12:07 PM
Conditional Formatting not working Crowbar via OfficeKB.com Excel Programming 1 November 19th 05 07:08 PM
Conditional formatting not working! Simon Lloyd[_420_] Excel Programming 13 May 8th 04 05:43 PM


All times are GMT +1. The time now is 05:06 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"