Conditional Formatting Help Req.
 

If I enter 1 in E5 cell then the conditional formatting should set the
background for A5 as Green. Like this wherever I enter 1 in E column cell
then the A Column cell should be highlighted in Green Back Ground.

If it is possible, then pls guide me.

Thanks in Advance

TGV

Conditional Formatting Help Req.
 

what will be the value in column A?
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"TGV" wrote:

If I enter 1 in E5 cell then the conditional formatting should set the
background for A5 as Green. Like this wherever I enter 1 in E column cell
then the A Column cell should be highlighted in Green Back Ground.

If it is possible, then pls guide me.

Thanks in Advance

TGV

Conditional Formatting Help Req.
 

In A column the dates will be available

"francis" wrote:

what will be the value in column A?
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"TGV" wrote:

If I enter 1 in E5 cell then the conditional formatting should set the
background for A5 as Green. Like this wherever I enter 1 in E column cell
then the A Column cell should be highlighted in Green Back Ground.

If it is possible, then pls guide me.

Thanks in Advance

TGV

Conditional Formatting Help Req.
 

To conditionally format your cell(s):

In 2003:
1. Select the cells you want to format (here I am assuming A5:A10)
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=E5=1
5. Click the Format button
6. Choose a color on the Patterns tab
7. Click OK twice.



--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis





"TGV" wrote:

In A column the dates will be available

"francis" wrote:

what will be the value in column A?
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked


Thank You

cheers, francis










"TGV" wrote:

If I enter 1 in E5 cell then the conditional formatting should set the
background for A5 as Green. Like this wherever I enter 1 in E column cell
then the A Column cell should be highlighted in Green Back Ground.

If it is possible, then pls guide me.

Thanks in Advance

TGV