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: 14
Default Rounding formula when using conditional formatting?

I have spreadsheet that has conditions and depending on those conditons the
cells changed color. For example: if cell is less than .29 or = to .29 turn
the cell red. Now this cell that has the actual number is next to the cell
that shows the % and then the color and the conditional cell has a formula in
it. =B12/$B$10. Example: Cell B12 =54 and cell B10 has a total formula thus
giving me the number 39. How can I put a formula in the cell that already has
the =B12/$B$10 that will round the number up say from .46 to .05 thus
updating my color? See right now it does not change to the next color even
though I decrease the decimal point. I want to round up in the condional
formatting. Help?
 
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 Formula bdmatlock Excel Worksheet Functions 5 May 21st 08 07:08 PM
Conditional Formatting Formula Studebaker Excel Worksheet Functions 1 October 12th 07 12:47 AM
what formula do I use for conditional formatting? CoopsCoops Excel Worksheet Functions 2 June 29th 07 02:56 AM
Conditional Formatting Formula DHEvans333 Excel Worksheet Functions 1 November 9th 06 08:51 PM
conditional formatting or formula CJRolls Excel Worksheet Functions 5 May 10th 06 06:12 PM


All times are GMT +1. The time now is 01:44 AM.

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"