Bug 58507

Created attachment 71793 [details]
Screenshots from 4.0 beta 1 to explain the confusion

Problem description: when selecting a cell and then selecting CF -> condition the rule only appears if the entire range that the conditional formatting rule applies to is selected (otherwise it may lead the user to believe that there are no conditional formatting rules applied to the selected cell)

Steps to reproduce:
1. open the example from bug 58484, attachment 71764 [details]
2. select cell AN7
3. select: format -> conditional formatting -> condition

Simpler steps to reproduce:
A. create a spreadsheet with a conditional formatting rule applied to A1:A2
B. select cell A1
C. select: format -> conditional formatting -> condition

Current behavior: the list is empty

Expected behavior: the list makes it clear by some means that there is a rule which applies to the selected cell, but that the range is different (e.g. yellow triangle at the top and "this cell has conditional formatting applied as part of a range to other cells click here to view all conditional formatting rules" - the link would open the 'Manage...' dialogue.

Workaround (for steps 1-3): select the exact range (T7:W46,Z7:Z46,AD7:AG46,AJ7:AJ46,AN7:AQ46,AT7:AT46) as listed under CF -> Manage, then select CF -> Condition and the rule is listed (presumably as the range at the bottom of the dialogue box now matches)

Alternative Workaround: always use CF -> Manage to deal with cells which may already contain conditional formatting to avoid getting confused
Operating System: Windows XP
Version: 4.0.0.0.beta1