Conditonal format based on another cell value

C

Camwyn

Hi,

I'd like to format a row, or part of a row, based on the value in one cell of the row...

The example I'm working on is a GPA calculator for my wife, we want to be able to add classes for future semesters, but format them differently based on the clomun "Semester" which has a number value so that the entire row is, say, bold fo past, italicised for future, plain for current.

Is this possible?

Thanks,
Camwyn
 
T

Trevor Shuttleworth

Camwyn

yes, you can do this quite easily:

in the conditional formatting dialogue, set the first condition to be:
Formula is =$A2="past"; set the format to bold.
use Add for more conditions. set the first condition to be: Formula is
=$A2="future"; set the format to italic.

You could add a third condition for the present and format this as regular.

Change past, present and future to your values and choose appropriate
formatting.

Regards

Trevor


Camwyn said:
Hi,

I'd like to format a row, or part of a row, based on the value in one cell of the row...

The example I'm working on is a GPA calculator for my wife, we want to be
Click to expand...
able to add classes for future semesters, but format them differently based
on the clomun "Semester" which has a number value so that the entire row is,
say, bold fo past, italicised for future, plain for current.
 
Top