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: 210
Default Change text colour if range of values all zero

Hi,

If all the values in cells E2:L2 = zero then change the font colour of cell
A2 to Red.

How do I achieve this please?

Thank you.
 
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
Change text colour according to number R.Demandt Excel Worksheet Functions 2 November 28th 06 08:24 AM
change text colour Jeff New Users to Excel 3 February 15th 06 05:53 AM
Quick Text colour change? mrrix32 Excel Discussion (Misc queries) 0 January 11th 06 04:30 PM
How do i make a range of cells change colour Spiller Excel Worksheet Functions 6 August 24th 05 02:11 PM
Change Colour OF Text??? James UK23 Excel Discussion (Misc queries) 1 May 19th 05 12:32 AM


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