Conditional Formatting

  oo7juk 10:53 03 Sep 09
Locked

Hi,

Can someone help with the following please:

1. When a date is entered in column AK that the row then changes colour.

2. When the word 'reject' is entered in column P then the row changes colour.

I know the basics of CF, using 'more than/greter than', but not entire rows, etc.

Many thanks.

  Jak_1 11:46 03 Sep 09

It would help if you told us just what program you are using and what it is that you want to achieve! I assume the program is 'Excel'.

  oo7juk 12:16 03 Sep 09

Thanks - the program is Excel 2003

The range is A5:AW2000

And I want to insert 2 CF's within range.

1.When I enter a date in column AK, then that complete row within the above range changes colour.

2. When the word "reject" is populated in column P, then that complete row changes a different colour.

Thanks.

  johnem 12:16 03 Sep 09

When you have selected the range of cells that you wish the CF to apply to, you can select "format" and then select either font colour or background. Once selected, if the cell value meets your preset criteria, the colour of the cell or font will automaticlly change to that selected in the "format" section.
Hope that tghis makes sense.

This thread is now locked and can not be replied to.

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos