Cell references

  • Thread starter Thread starter Python
  • Start date Start date
P

Python

I'm trying to use functions to change patterns in some
cells. The patterns refer to a cell that the formula
doesn't affect. For instance, B1 to F1 has a pattern that
depends on whether or not A1 is empty, and then if any of
those cells are empty, they have another pattern. Is it
possible to evaluate each cell seperately within a group,
and apply the pattern to the single cells, without
applying the formula to each cell individually?
 
Python,

Depends upon what sort of pattern that you want. If it is just colour, then
you can use Conditional Formatting off the Format menu. You can put a
condition in for a range of cells, and assign a pattern colour, those that
match the condition will assume the colour.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Hi Pyton
hope I understood you correctly. Try the following
1. Select/highlight cells B1-F1
2. Goto 'Format - Conditional Format'
3. Enter the first condition (formula):
=AND($A$1<>"",B1<>"")
apply the first format for the condition: A1 is not empty and the
respective cell in B1-B1 is also not empty
4. Enter the seond condition:
=AND($A$1<>"",B1="")
and choose your format

HTH
Frank
 
Back
Top