Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 6th 15, 08:26 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2012
Posts: 38
Default Conditional formating Excel 2010

Help please:
I have some look up formulas on a spreadsheet and I have this row to showup red if a cell is larger than the median wich I have a formula at the bottom of each row.
Everything is working fine excep the blank cells also turn red even tho the formula is displaying a blank cell
So basically I need the conditional formating to ignore blanks, keep in mind I have formulas on each cell so is probably taking that in consideration.

Thank you in advance

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 in Excel 2010 Duncan Edment[_3_] Excel Discussion (Misc queries) 2 December 9th 14 12:31 PM
CONDITIONAL FORMATTING IN EXCEL 2010 Malcolm Austin Excel Worksheet Functions 1 May 16th 13 12:20 PM
Excel 2010 Conditional Formatting rjbabbidg Excel Worksheet Functions 2 February 27th 13 08:00 AM
Conditional Formatting in Excel 2010 is being removed when I emailExcel Workbook [email protected] Excel Programming 0 April 25th 12 09:59 PM
Help with conditional formatting in Excel 2010 Ian R[_4_] Excel Worksheet Functions 8 February 14th 12 01:08 AM


All times are GMT +1. The time now is 10:47 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017