Conditonal format based on another cell value

[Guest]

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

 

[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

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.

 

[Guest]

Thanks! Took a bit of tweaking to get it the way I wanted it, but it works great!

 

[Trevor Shuttleworth]

You are very welcome

Thanks! Took a bit of tweaking to get it the way I wanted it, but it works

great!