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: 6
Default Conditional Formatting Issue

I have conditional formatting on a set of cells with 3 conditions.
If number in cell A3 is equal to number entered in cell B 3 it Green and Bold
if the number in cell B 3 is less than A3 it is red
If the number in cell B3 is greater than A3 it is red and Bold

The conditional formatting works in all by one cell and for some reason no
matter what number is in the cell it does not accept the formatting- I have
tried pulling the conditional formatting off, redoing it all to no avail. I
am stumped

Any ideas?
 
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 Issue Robert Excel Discussion (Misc queries) 8 September 1st 08 11:05 PM
Excel - conditional formatting issue Raj Excel Discussion (Misc queries) 3 May 23rd 08 03:36 PM
Conditional Formatting Issue afsoares Excel Discussion (Misc queries) 3 June 30th 06 01:36 PM
conditional formatting issue QUESTION-MARK Excel Worksheet Functions 3 April 20th 06 01:04 AM
formatting issue? chip_pyp Excel Discussion (Misc queries) 4 January 31st 06 09:22 PM


All times are GMT +1. The time now is 06:13 AM.

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

About Us

"It's about Microsoft Excel"