Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
dona
 
Posts: n/a
Default apply conditional formatting to negative cell values

I am creating a time sheet and want to show negative values in red. Does
anyone know how to do this?

Thanks
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips
 
Posts: n/a
Default apply conditional formatting to negative cell values

Just set the condition to less tan and a value of 0 in CF.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dona" wrote in message
...
I am creating a time sheet and want to show negative values in red. Does
anyone know how to do this?

Thanks



  #3   Report Post  
Posted to microsoft.public.excel.misc
dona
 
Posts: n/a
Default apply conditional formatting to negative cell values

That's great, all sorted now, thank you

"Bob Phillips" wrote:

Just set the condition to less tan and a value of 0 in CF.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"dona" wrote in message
...
I am creating a time sheet and want to show negative values in red. Does
anyone know how to do this?

Thanks




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 to Test Value in Cell Carroll Excel Worksheet Functions 3 March 9th 06 07:38 PM
Conditional Formatting Cell < Today() sagan Excel Worksheet Functions 3 September 21st 05 03:43 PM
Conditional formatting a full row triggered by a single cell neilcarden Excel Worksheet Functions 1 August 17th 05 06:25 PM
Conditional formatting a full row triggered by a single cell reference... neilcarden Excel Worksheet Functions 1 August 17th 05 02:59 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM


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