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: 38
Default Conditional format but referred from other cell

How can do this:

A:A contain date
B:B has a formula e.g for B1 =if(A1=today(), "today", "")
B2 =if(A2=today(), "today", "") etc

C:C has some data


I would like to bold the data in cell C if the corresponding B is "today"


Thanks




 
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
Help with this conditional IF statement C-Dawg Excel Discussion (Misc queries) 3 May 15th 06 06:01 PM
conditional cell format Gary King Excel Discussion (Misc queries) 2 September 16th 05 02:12 PM
Conditional Format to highlight blank cell DaveMoore Excel Worksheet Functions 4 June 23rd 05 10:10 AM
Office2000: Conditional format behaves strangely Arvi Laanemets Excel Discussion (Misc queries) 1 April 7th 05 08:47 AM
Can I create a conditional format in a cell using a value from an. thrasher Excel Discussion (Misc queries) 3 February 4th 05 05:17 PM


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