LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 465
Default Conditional Formatting assistance


Hi All

I'm trying to solve an issue with conditional formatting.

Essentially , if any of the cells in the selected area contain 0.00 ,
colour every selected cell red.

eg:

1 16.00 2.00 3.5 1.20
2 18.00 2.00 2.5 1.28
3 20.00 2.00 1.5 1.33
4 22.00 0.00 0.0 1.33
5 22.00 0.00 0.0 1.33
6 22.00 0.00 0.0 1.33
7 22.00 0.00 0.0 1.33

In this example all the cells in rows 4 to 7 would be red.

Can someone advise?
 
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 Assistance wendy Excel Worksheet Functions 4 March 21st 10 05:49 PM
Looking for assistance for an unusual conditional formatting probl John C. Excel Discussion (Misc queries) 2 November 9th 09 10:07 AM
Formatting Assistance Randy Excel Discussion (Misc queries) 2 February 6th 09 08:13 AM
Conditional Formatting - further assistance required Aaron Hodson \(Coversure\) Excel Worksheet Functions 2 October 8th 07 01:16 PM
Conditional Formatting Assistance JimMay Excel Discussion (Misc queries) 4 May 13th 06 06:46 PM


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